Skip to content

Instantly share code, notes, and snippets.

@AsifMushtaq

AsifMushtaq/PIVOT

Created August 14, 2014 00:17
Show Gist options
  • Save AsifMushtaq/1503b325eb4ce433a245 to your computer and use it in GitHub Desktop.
Save AsifMushtaq/1503b325eb4ce433a245 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
PIVOT
;WITH BaseQuery AS(
SELECT TotalDue, YEAR(OrderDate) AS OrderYear,
DATENAME(MONTH,OrderDate) AS OrderMonth
FROM Sales.SalesOrderHeader
)
SELECT OrderYear,January,February,March,April,May,
June,July,August,September,October,November,December
FROM BaseQuery
PIVOT(SUM(TotalDue) FOR OrderMonth IN (January,February,March,
April, May,June,July,August,September,October,November,
December)) AS PVT
;WITH BaseQuery AS(
SELECT TotalDue, YEAR(OrderDate) AS OrderYear,
MONTH(OrderDate) AS OrderMonth
FROM Sales.SalesOrderHeader
)
SELECT OrderYear,[1] AS [January],[2] AS [February],
[3] AS [March],[4] AS [April],[5] AS [May],[6] AS [June],
[7] AS [July], [8] AS [August],[9] AS [September],
[10] AS [October], [11] AS [November],[12] AS [December]
FROM BaseQuery
PIVOT(SUM(TotalDue) FOR OrderMonth IN ([1],[2],[3],[4],[5],
[6],[7],[8],[9],[10],[11],[12])) AS PVT
ORDER BY January DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment