Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 CrossTab Report/Query

Author  Topic 

ikhuram
Starting Member

28 Posts

Posted - 2004-05-26 : 10:41:32
How to make a cross tab query if the number of columns is not specific/fixed.

drymchaser
Aged Yak Warrior

552 Posts

Posted - 2004-05-26 : 10:43:36
Search the site for "Dynamic Cross-tab" there is an excellent article on it for you.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2004-05-26 : 13:37:15
You know...I should created that sproc a long time ago....

An oldie but a goodie..

http://www.sqlteam.com/item.asp?ItemID=2955

No, not you Rob....how old are you now?

And where you bean? On Vay-kay?



Brett

8-)
Go to Top of Page
   

- Advertisement -