SELECT SUM(CASE WHEN type = 'open' AND Name ='TT' THEN [count] ELSE 0 END) AS TTOpen,
SUM(CASE WHEN type = 'closed' AND Name ='TT' THEN [count] ELSE 0 END) AS TTClosed,
SUM(CASE WHEN type = 'open' AND Name ='AA' THEN [count] ELSE 0 END) AS AAOpen,
SUM(CASE WHEN type = 'closed' AND Name ='AA' THEN [count] ELSE 0 END) AS AAClosed
FROM Table
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
SQL Pivot help
Posted - 07/15/2012 : 17:31:59
