... with clubs.

I'll raise that to six DBA's!

Now that the points have been correctly awarded, those points received by discussion posts could be reduced: "Hey! I didn't get my point, I'll send ten posts to compensate..." :hehe:

Nice QotD. It would have been more educational with third section

select @C = 'test', @c1 = null, @d = '01/01/10', @d1 = '01/01/10',

which brings nullif into fray...

Are your statistics up to date? Run this before your update:

UPDATE STATISTICS [tablename] WITH FULLSCAN

Once I encountered similar problems: affected rowcount seemed to be quite random on repeated runs with...

... And now the original correct choice does not give point...:ermm:

Here is another approach to this problem that I have not seen yet on this thread.

done based on mister magoo's testdata...

/*

* get all values into single column

*/

SELECT id,...