SELECT fnr
WHEN MAX(CASE WHEN pnr='priv' THEN 1 ELSE 0 END)=1 THEN 'Yes' ELSE 'No' END
FROM table
GROUP BY fnr

quote:

---

Originally posted by visakh16

SELECT fnr,
CASE WHEN MAX(CASE WHEN pnr='priv' THEN 1 ELSE 0 END)=1 THEN 'Yes' ELSE 'No' END
FROM table
GROUP BY fnr

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

---