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