There are times you want crosstab data on SQL Server, especially with Access ADP projects, but writing crosstab code on SQL Server 2000 can't really be done effectively. 

If you know...