• To all the people who responded that they are happy to have learned the SOME operator ... please unlearn it, as soon as possilble.

    Every expression with SOME (and its companions ANY and ALL) can be replaced with an EXISTS operator. There is no reason to ever use these operators. I have never seen them in actual code, and I will never use them.


    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/