Pivoting, Un-pivoting and Aggregating
Techniques in pivoting and un-pivoting data, and showing how the use of the CUBE or ROLLUP operator can be a more efficient way of generating reports by Phil Factor.