Give the New PIVOT and UNPIVOT Commands in SQL Server 2005 a Whirl

Give the New PIVOT and UNPIVOT Commands in SQL Server 2005 a Whirl: "
Give the New PIVOT and UNPIVOT Commands in SQL Server 2005 a Whirl
Sometimes it's the little things that can simplify your life the most. Learn to combine SQL Server's PIVOT and UNPIVOT commands with Common Table Expressions to make your T-SQL code easier to read and produce more useful crosstabbed results.

by Michael Jones May 20, 2005"