PIVOT and UNPIVOT
SQL Server 2005 added the PIVOT clause to T-SQL. A typical analytical use of the PIVOT command is to convert temporal data into categorized data to make the data easier to view and analyze.
The first and simplest option for returning the temporal data is to query the data, grouping the fact information in such a way that it answers the questions being asked. For example, Listing 45.41 retrieves data from the SalesOrderDetail table and provides the total number of Products sold, by year. Note that it’s difficult to see trends of the number of Products sold between years. It is also even more difficult to answer questions about how sales of one product compared to sales of other products in the same year.
LISTING 45.41 A Standard ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
