dwain.c (9/30/2013)

---

Mark-101232 (9/30/2013)

---

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);

Mark,

I don't think you need to COUNT DISTINCT Category within Project as Project, Category is the primary key (IGNORE_DUP_KEY = OFF).