Here's an interesting combination:

This code works perfectly OK ( the unmatched block comment marker causes no problems because it is part of an inline comment):

print '1'

--/*note unmatched block comment...

Got it wrong , read the answer/explanation, didn't really believe it, so tried it in Query Analyser which gave the answer stated as the solution. But I still...

Yes, employee 45 SHOULD show up in this list, because nobody reports to them.

Add another record where someone reports to 45, then 45 will not appear - even...

Good question, and good comment to explain the result and the fact that it depends on ANSI_NULLS setting.

It got me thinking about the other IN / NOT IN syntax as...