Multiple Resources with multiple names

Question

Sorry if this may seem simple, maybe it's Friday and my brain just isn't working. I have been trying to figure out the best way to handle a problem for 4 or so hours and can't come up with the best answer. Hopefully you guys can help me out. I am working with MSSQL

I need to concatenate these "Names" as a single string delimited by commas. And only show the single ID. ie.. |ID1 | name1,name2,name3|.

I have never done this and cannot locate the resources to figure it out. I am sure there is some way you can coalesce it, but I can't figure it out. Thanks for your time in advance.

ID NAME

ID1 NAME1

ID1 NAME2

ID1 NAME3

ID2 NAME2

ID2 NAME3

ID3 NAME1

ID4 NAME2

SELECT s2._ResourceGuid, s2.SoftwareCount, s2.RPMList FROM (SELECT rpm._ResourceGuid,count(rpm.name) AS SoftwareCount, (???????) as SoftwareList FROM Inv_Unix_RPMInfo rpm WITH (NOLOCK) WHERE rpm.Name ='VRTSvxvm' OR rpm.Name = 'VRTSvxfs'
OR rpm.Name = 'VRTSvcs' GROUP BY _ResourceGuid )s2

Possible duplicate: http://stackoverflow.com/questions/122942/how-to-return-multiple-values-in-one-column-t-sql — Kevin Peno, Mar 18 '11 at 16:09

score 1 · Answer 1 · edited May 23 '17 at 12:19

1

MySQL has a great non-standard function for this called GROUP_CONCAT. I found a few articles on how to do this in MSSQL with a quick googling. Here's one now:

How to return multiple values in one column (T-SQL)?

edited May 23 '17 at 12:19

Community

1
1

answered Mar 18 '11 at 16:03

Kevin Peno

9,107
1
33
56

Thanks for the help.. Sorry I didn't use the resources available. – Justin Mar 18 '11 at 16:12
@Justin, no problems. Glad I could help either way ;) – Kevin Peno Mar 18 '11 at 16:13

Multiple Resources with multiple names

ID NAME

1 Answers1