In SQL Server 2000 there was not a simple way to create cross-tab queries, but a new
option in SQL Server 2005 has made this a bit easier. This new option in SQL Server 2005 is
called PIVOT and makes the job of creating cross-tab queries much easier then