Need Output in comma seperated

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)

Need Output in comma seperated

Author

Topic

ganeshkumar08
Posting Yak Master

187 Posts

Posted - 2011-08-17 : 03:09:52

Hi All,

below is my resultset
---------------------------------
SCHEDULEID | USERID | COURSEID
---------------------------------
2005141 | 5001330 | 16822
2005141 | 5001331 | 16822
2005141 | 5001331 | 17100
--------------------------------

From the above result set i need output as below
---------------------------------
SCHEDULEID | USERID | COURSEID
---------------------------------
2005141 | 5001330 | 16822
2005141 | 5001331 | 16822,17100
---------------------------------

Thanks
Ganesh

Solutions are easy. Understanding the problem, now, that's the hard part

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-08-17 : 03:16:50

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254

KH
[spoiler]Time is always against us[/spoiler]

ganeshkumar08
Posting Yak Master

187 Posts

Posted - 2011-08-17 : 04:38:25

Thanks

Solutions are easy. Understanding the problem, now, that's the hard part

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources