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

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

Show quoteHide quote

Hi, Jim

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

Thanks
Show quoteHide quote

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,

Show quoteHide quote

Fastest way to update a Picturebox's image
Dynamic Properties
converting API call
Editing XML Document
Sub Main Ends so does the application
Add object to listview
Setting focus to a combobox in a grid
Call EXE method from DLL using named instance
SSH FTP componet
Notify Icon not being displayed