the below code will give you the borrownumber groups without dDirect tag in them
SELECT *
FROM
(
SELECT *,COUNT(CASE WHEN TagName = 'dDirect' THEN 1 ELSE NULL END) OVER (PARTITION BY BorrowNumber) AS DirectCnt
FROM Table
)t
WHERE DirectCnt=0
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
GROUP BY COUNT
Posted - 02/04/2013 : 23:25:40
