Pivots

Pivoting

the Pivot is like a transcribe operator in excel. You take the top left point, anchor it and then flips the axis' and their values.

SELECT Name
	,pvt.Low
	,pvt.Med
	,pvt.High
	,pvt.Ultra
FROM Person
PIVOT
	(SUM(Total) FOR Level IN ([Low], [Med], [High], [Ultra])
	) AS pvt

UN-pivoting

SELECT Name
	,upvt.Level
	,upvt.Total
FROM Person
UNPIVOT
	(Total FOR Level IN ([Low], [Med], [High], [Ultra])
	) AS upvt

Advanced Pivoting

https://www.mssqltips.com/sqlservertip/7167/sql-pivot-grouping-sets-advanced-reporting/

---

Children

1. Example