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
 SQL Server Development (2000)
 data return

Author  Topic 

skillile
Posting Yak Master

208 Posts

Posted - 2005-01-09 : 17:54:51
I have data in row format ie:

datatype datavalue createddate
1 value
2 value
3 value
4 value
1 value
2 value
3 value
4 value


It is not a GROUP BY. the above would return 2 rows

TYPE 1 TYPE 2 TYPE3 TYPE 4
value value value value
value value value value

not sure how to do it without a ton of while loops. I've looked at the pivot ideas.

Also the types are dynamic.

Any ideas would be great.

thanks

-sk



slow down to move faster...
   

- Advertisement -