Setting that affects "NOT IN" predicate?

  • 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

  • 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]

  • 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

  • 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