SELECT G,
ROW_NUMBER() OVER (ORDER BY MIN([Key])) AS [Key],
SUM(CASE WHEN Pr='CW' AND Type='EL' THEN cost ELSE 0 END) AS [CW EL],
SUM(CASE WHEN Pr='CW' AND Type='NL' THEN cost ELSE 0 END) AS [CW NL],
SUM(CASE WHEN Pr='CW' AND Type='EL' THEN cost ELSE 0 END) AS [im EL],
SUM(CASE WHEN Pr='CW' AND Type='NL' THEN cost ELSE 0 END) AS [im NL]
FROM table
GROUP BY G
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
SQl query presented data in pivot way - edited
Posted - 07/16/2012 : 08:34:43
