Posted by D i s h a n on 03/20/06 10:13

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

• Next in forum: Possible to disable welll-formedness checking when inserting XML data.
• Prev in forum: Re: add a column specified location in Table..
• Thread view: Row to Column

[Reply to this message]