Incorrect Result of “IN” Clause Don’t use “IN” anymore! Solution: EXISTS http://beyondrelational.com/modules/2/blogs/77/posts/11302/t-sql-worst-practices-a-compilation-from-jacobs-session-at-tech-ed-2011-part-01-practices-that-affec.aspx