March 9, 2008 at 9:54 am
I had a co-worker mention there was a setting in SQL Server 2000 that would affect the results of a NOT IN subquery. I have looked through all the BOL and the internet but have not found anything. The only thing that I have found is related to results dealing with a NULL.
Does anyone know of a setting, database or server or sql statement, that would change how SQL returns the results?
Thanks,
Geneva
March 9, 2008 at 11:59 am
Geneva Payne (3/9/2008)
I had a co-worker mention there was a setting in SQL Server 2000 that would affect the results of a NOT IN subquery. I have looked through all the BOL and the internet but have not found anything. The only thing that I have found is related to results dealing with a NULL.Does anyone know of a setting, database or server or sql statement, that would change how SQL returns the results?
Thanks,
Geneva
Affect it to do what?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 9, 2008 at 12:35 pm
Maybe the are referring to potentially use NOT EXISTS instead of NOT IN ?
http://decipherinfosys.wordpress.com/2007/01/21/32/
http://blogs.geekdojo.net/richardhsu/archive/2004/10/05/3325.aspx
March 10, 2008 at 7:35 am
They mentioned that this setting would affect whether the "NOT IN" would return the correct results or not. I will have to determine if they might have been talking about the NOT EXISTS.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply