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)
 Re-order rows and columns

Author  Topic 

vladimir_grigoro
Yak Posting Veteran

62 Posts

Posted - 2003-02-12 : 08:50:58
Hi All,
I have a table with data for example:
2 X XA
2 X XB
2 X XC
2 X XD
3 Y YA
4 Z ZA

I want to make a SELECT statement to receive INFORMATION like that in one recordset, on the empty places there could be NULL.

2 X XA XB XC XD
3 Y YA
4 Z ZA

Thank you in advance.

The Rebel

Edited by - vladimir_grigoro on 02/12/2003 09:37:34

simondeutsch
Aged Yak Warrior

547 Posts

Posted - 2003-02-12 : 11:10:59
One of the most popular questions...
Have a look at these articles:
http://www.sqlteam.com/item.asp?ItemID=256
http://www.sqlteam.com/item.asp?ItemID=11021

Sarah Berger MCSD
Go to Top of Page
   

- Advertisement -