Posted by Simon Hayes on 10/01/43 11:27

If you got no rows, is it possible that your subquery result included a
NULL? NOT IN combined with a NULL returns an empty set; NOT EXISTS
returns all the non-NULL values. Google for 'sql "not in vs not
exists"' or something similar and you'll find plenty of discussions
about this.

Simon

• Next in forum: Re: Is there a way to find growth in log (ldf) and database(mdf) ?
• Prev in forum: Re: XP and Replication
• Thread view: Re: search on concatenated fields in sql server

[Reply to this message]