http://vishnuprasad.com/archive/2009/04/13/PIVOT-in-SQL-Server-2005.aspxWe can use PIVOT relational operator to change a table-valued expression into another table. PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs aggregationsenCommunityServer 2.1 (Build: 60804.900)