CODEWITHSUNDEEP
sqlsql-serversql-server-2008
Pooja
Pooja

Reputation: 495

How to concatenate values with same id in sql

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?

Upvotes: 1

Views: 8914

Answers (1)

Rizvan
Rizvan

Reputation: 717

These both links help u to do this task :

http://jahaines.blogspot.com/2009/07/concatenating-column-values-part-2.html
http://jahaines.blogspot.com/2009/06/concatenating-column-values-part-1.html

Upvotes: 1

Related Questions