Show multiple record items in first record field

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 2008 Forums

Transact-SQL (2008)

Show multiple record items in first record field

Author

Topic

sadderson
Starting Member

13 Posts

Posted - 2009-05-20 : 00:28:18

I would like to know if it is possible to issue a select statement and get the following..

Input table
Item Response
1 Blue
2 Blue
1 Red
1 Green
2 Orange

Output Table

Item Response
1 Blue, Red, Green
2 Blue, Orange

so the input table has multiple rows the output table only has one for each item and concatinates the 'Response'.

Thanks in advance..

Scott

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-05-20 : 00:30:52

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

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