Concatenate multiple rows into one

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)

Concatenate multiple rows into one

Author

Topic

KlausEngelInc
Starting Member

8 Posts

Posted - 2009-08-21 : 10:33:07

I have two tables
table1 with columns userID , name
table2 with columns userID , colors

table1 has userID as primery key.
table two has multiple entries per userID

When I am joining the two tables I'd like to get a result set that looks like
userID | name | 'colorvalue1, colovalue2, colorvalue3'

Is there a function to do this?

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-08-21 : 10:35:41

see concatenate records without UDF

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

KlausEngelInc
Starting Member

8 Posts

Posted - 2009-08-21 : 10:56:20

Thanks, works great!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources