Getting Data separated by comma,

Question

I have one table like this..

TicketID    Name   

111         ABC
111         DEF
222         GHI
333         ABC
333         GHI

I need output like this..

TicketID    Name   

111         ABC, DEF
222         GHI
333         ABC, GHI

I have found a same kind of query try to do it with Stuff function but don't know why m not getting exact result Can anyone give me query for SQL Server.. n tell me how actually it process.

If you have a query that doesn't work, you should include that in your question. We cannot read your mind in trying to explain why it doesn't work. — Gordon Linoff, Nov 24 '14 at 11:59
yeah u r right.. I thought it would be good if I ask for query then understand it. its ok — Vikrant Mishra, Nov 24 '14 at 12:06

score 1 · Accepted Answer · edited May 23 '17 at 11:58

1

Like here, here or here.

SELECT 
  [TicketId],
  STUFF((
    SELECT ', ' + [Name]) 
    FROM [OneTable] 
    WHERE ([TicketId] = OT.[TicketId]) 
    FOR XML PATH(''),TYPE).value('(./text())[1]','VARCHAR(MAX)')
  ,1,2,'') AS Name
FROM [OneTable] OT
GROUP BY [TicketId]

Go and vote it up, then close this question.

edited May 23 '17 at 11:58

Community

1
1

answered Nov 24 '14 at 12:00

Jodrell

34,946
5
87
124

thank bro..got it...I was not doing group by and not had where command in the stuff function..thanx alot – Vikrant Mishra Nov 24 '14 at 12:20

Getting Data separated by comma,

1 Answers1