Crosstab queries using PIVOT in SQL Server 2005

Here is some links that shows how to convert rows to column using PIVOT, the new feature in Sql Server 2005.

(1) Using PIVOT and UNPIVOT

(2) Crosstab queries using PIVOT in SQL Server 2005

(3) Andras : Pivots with Dynamic Columns in SQL Server 2005

(4) Write PIVOT queries in SQL Server 2005

(5) Dynamic PIVOT in SQL Server 2005