How to merge multiple rows into single row if the id is same?

Question

id   name   
2    ravi kumar    
2    mohit kumar   
...

and I want to result

id name   
2 ravi kumar / mohit kumar    
...

Thanks

Answer 1

This is one way you can resolve the issue:

SELECT DISTINCT ID,
  STUFF((SELECT DISTINCT '/' + Name
         FROM Table1 t2
         WHERE t1.ID = t2.ID
            FOR XML PATH(''), TYPE
            ).value('.', 'NVARCHAR(MAX)') 
        ,1,1,'') data
FROM Table1 t1;