-- You need this because the previous lines only set the values, they won't print themselect @val

-- Tidy up the temp tabledrop table #empty

just uncomment the line you want to test with.You could just create the temp table once and then declare your variables etc, but I didnt think efficiency was necessary for this, so I just copied and pasted :)

And NULL's can be cool, they just need some understanding, although that list keeps growing as you start exploring more and more functionality that SQL Server has to offer.

Admittedly I tried to answer it prior to testing and got it wrong :PYou live and learn...

O' and unless Steve fixed it after the last post, it was a select list, not a multiple choice :)

David B (4/6/2009)O' and unless Steve fixed it after the last post, it was a select list, not a multiple choice :)

Are you sure? I just replied to the question, and had no trouble checking both the options I expected to be correct.

It is of course not impossible that Steve fixed it between the time of your post and now, but not likely, considering that it's somewhere in the middle of the night in his part of the world. He usually fixes QotD issues when it's in the afternoon in my part of the world (Europe), about six hours from now....

David B (4/6/2009)O' and unless Steve fixed it after the last post, it was a select list, not a multiple choice :)

Are you sure? I just replied to the question, and had no trouble checking both the options I expected to be correct.

It is of course not impossible that Steve fixed it between the time of your post and now, but not likely, considering that it's somewhere in the middle of the night in his part of the world. He usually fixes QotD issues when it's in the afternoon in my part of the world (Europe), about six hours from now....

OOPS! Did not even consider you could tick more than one box . . . my mistake!So there go 2 lost bragging points . . . ;-(Thanks for the lesson, though!