How to concatenate values with same id in sql

Question

My table contains the details like with two fields:

User ID  Rolename
1        Editor
1        Reviewer
7        EIC
7        Editor
7        Reviewer
19       EIC
19       Editor
19       Reviewer

I want get the unique details with RoleName like

1 Editor,Reviewer
7 EIC,Editor,Reviewer

How to combine RoleName Details? How to write the Query?

possible duplicate of [Concatenate values based on ID](http://stackoverflow.com/questions/6603319/concatenate-values-based-on-id) — Mikael Eriksson, Dec 15 '11 at 08:09
Thanks to all.I got the answer.SELECT DISTINCT U.UserID, U.FirstName + ' ' + U.LastName AS Name,Mobile,Email,UserName, SUBSTRING((SELECT ', ' + A.RoleName FROM NZF_UserRoles A INNER JOIN NZF_RolesForUsers B ON A.RoleID=B.RoleID AND B.UserID = U.UserID FOR XML PATH ('')),3,1000) AS RoleName FROM NZF_Users U ORDER BY UserName ASC — Pooja, Dec 15 '11 at 08:17

score 1 · Accepted Answer · answered Dec 15 '11 at 07:29

1

These both links help u to do this task :

answered Dec 15 '11 at 07:29

Rizvan

1 Answers1