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