create crosstab in sql server 2000greenspun.com : LUSENET : SQL Server Database Administration : One Thread
I WANT TO CREATE CROSSTAB VIEW IN SQL SERVER 2000 SAME OF CROSSTAB QUERY IN ACCESS
-- Anonymous, October 16, 2004
Basically you have to do it manually. An example is shown in the SQL Server Books Online topic, "Cross-Tab Reports".
-- Anonymous, October 18, 2004