Microsoft SQL Server forum

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Row to Column

D i s h a n

2006-03-21, 3:30 am

Hi experts,

Ex. Data set in TableA

ID, Value
--------------
1,A
2,B
1,F
3,C

Expected result set

ID, Value
-------------
1,A,F
2,B
3,C

Can I do this with T-SQL?

Thanks.

Regards
Dishan

markc600@hotmail.com

2006-03-21, 3:30 am

Check out

http://www.aspfaq.com/show.asp?id=2529

D i s h a n

2006-04-05, 3:28 am

Thanks mark

khatri

2006-04-05, 3:28 am

Hi Mark,

Please tell me how to do the following :

ID Col#1 Col#2
1 A F
2 B
3 C

I want to post the values in seperate columns.

Regards,

Khatri

Sponsored Links