By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,364 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,364 IT Pros & Developers. It's quick & easy.

How toTranspose a row values in to column values

P: 94
Hi all,
I 've a following table with two columns id & name.
Table : A

id name
1 A
1 B
1 C
2 D
2 E
3 F

and I need the output like this with four columns id,name1,name2 &name3.
Table: #B
id name1 name2 name3
1 A B C
2 D E NULL
3 F NULL NULL
I dont know how to implement. Sorry for the bad alignment.Pivot table will not work for this. I am still trying. Any help is greatly thankful. plz help.....
Mar 27 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.