PIVOT and UNPIVOT are relational operators that, like CTEs, are geared toward BI applications. To put it briefly, PIVOT provides the basic operation required for crosstabs, effectively converting columns into rows. UNPIVOT does the reverse, converting rows into columns. This allows you to perform quick crosstabs without having to use OLAP. This is a great feature for report building!