cross-tab query for SQL server DB

[martin1]

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]

Re: cross-tab query for SQL server DB

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

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

[martin1]

Re: cross-tab query for SQL server DB

Hi, Jim

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

Thanks
"Jim Wooley" wrote:

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

>

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

>
>
>

[martin1]

Re: cross-tab query and combine 2 dataGridView

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,

"martin1" wrote:

Hi, Jim
>
My SQL Server is 2000, the pivot and Unpivot work for sql server 2000?
>
Thanks
"Jim Wooley" wrote:
>

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

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