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 2005 Forums
 Transact-SQL (2005)
 CSV Query

Author  Topic 

Shilpa22
Starting Member

37 Posts

Posted - 2010-10-07 : 08:16:21
Hello frnds,
I have a resultset as below
ID Name
8 aa
5 bb
5 cc
I need the resultset as
8 aa
5 bb,cc
How can I achieve this. Please help me out

Thanks in Advance
Shilpa

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-10-07 : 08:43:34
The below link got various method to get what you want.
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254
Go to Top of Page

pk_bohra
Master Smack Fu Yak Hacker

1182 Posts

Posted - 2010-10-08 : 03:45:10
Can you provide sample table and data.
Go to Top of Page
   

- Advertisement -