|
Posted by David Portas on 09/25/07 11:27
Yes. The real question is in the requirement not in the solution: What
do you want to happen if a single name has more than one colour? The
first example UPDATE has a dubious bug/feature that says "I don't care
- pick one of those colours at random". In the second case the answer
is "I do care - warn me about it so that I can fix the problem
properly".
--
David Portas
SQL Server MVP
--
Navigation:
[Reply to this message]
|