Cross Tab in SQL Server 2000
Today, I got a note from one of the blog readers on this very topic and thought it is worth making a mention over the blog rather than sending replies everytime to different people. I am sure this will be useful to someone googling over the internet :) ...
MSDN - Cross-Tab Reports
SQL Magazine Article - Dynamic Crosstab Queries
from Fellow MVP, Itzik Ben
From the SQLTeam site - Dynamic Cross-Tabs/Pivot Tables
Some third party tools that specialize on this requirement and if you have the extra $$$ you can also think on these lines.
GeckoWare Australia - SQL Crosstab Builder for Microsoft SQL Server
http://www.ag-software.com/Content.aspx?Doc_id=1002
Very famous and quite a lot of times refered on the Newsgroups is:
RAC - http://www.rac4sql.net/