cross-tab query for SQL server DB

[Guest]

rHi, All

I knew cross-tab quesy is easy done on the Access DB, is there easy way to
do cross-tab query for SQL server DB in VB.NET 2005 Dev environment? Thanks

 

[Jim Wooley]

SQL 2005 adds the Pivot and Unpivot keywords to TSql. see http://msdn2.microsoft.com/en-us/library/ms177410.aspx
Jim Wooley
http://devauthority.com/blogs/jwooley/default.aspx

 

[Guest]

Hi, Jim

My SQL Server is 2000, the pivot and Unpivot work for sql server 2000?

Thanks

 

[Guest]

Hi, All,

Crosstab is not easy for sql 2000 DB, but alternative solution is query each
pivot parameter separatly, then combine each dataGridView/DataTable together,
anyone know hwo to consolidate the dataGridView/DataTable?

Thanks,