Using PIVOT and UNPIVOT Books Online SQL Server UNPIVOT UNPIVOT PIVOT UNPIVOT PIVOT / UNPIVOT clauses Microsoft Tech Note Using PIVOT and UNPIVOT Using PIVOT and UNPIVOT article on MSDN PIVOT / UNPIVOT clauses Pivoting on TechNet article on MSDN Using PIVOT and UNPIVOT