Advertisement
Guest User

Untitled

a guest
Jun 29th, 2016
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. SELECT * FROM (SELECT
  2. SUM(Cost) AS Cost,
  3. CONVERT(VARCHAR(3), DATENAME(MONTH, DATEADD(MONTH, MONTH(MonthCol), - 1))) MonthCol
  4. FROM myTable WHERE YEAR(MonthCol) = 2016
  5. GROUP BY MonthCol) AS TP
  6. PIVOT (SUM(Cost) FOR MonthCol IN ([Jan], [Feb], [Mar], [Apr], [May], [Jun], [Jul], [Aug], [Sep], [Oct], [Nov], [Dec])) AS PVTTable
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement