WITH CategoriesWanted([Category]) AS (

SELECT [Category]

FROM ( VALUES (3),(6)) x([Category])

)

SELECT [Project]

FROM [dbo].[Project_Category]

WHERE [Category] IN (SELECT [Category] FROM CategoriesWanted)

GROUP BY [Project]

HAVING COUNT(DISTINCT [Category])=(SELECT COUNT(*) FROM CategoriesWanted);

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537