Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones SOME RE: SOME

  • March 21, 2012 at 8:26 am

    #1462168

    KWymore (3/21/2012)

    Are there any instances where you could not perform the same logic using IN instead of ANY?

    Yes, as GSquared already shows.

    However, there are (as far as I know) no cases where an ANY or SOME could not be replaced by an equivalent EXISTS subquery.

    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/