SQL:- Multiple rows to a single comma-separated value

Sample Data

DECLARE @MyTable1 TABLE(ID INT, Value Varchar(50))

INSERT INTO
@MyTable1 VALUES (1,'John'),(1,'Tom'),(1,'Sajan'),(1,'Ram')

Sql Query

SELECT 
ID

       ,STUFF((SELECT ', ' + CAST(Value AS VARCHAR(200)) [text()]

        FROM @MyTable1 

         WHERE
         ID = t.ID

         FOR XML PATH(''), TYPE)

        .value('.','NVARCHAR(MAX)'),1,2,' ') Name

FROM @MyTable1 t

GROUP BY
ID

Results

 
 
 


  
ID
  
Names
 

  
1
  
John, Tom, Sajan, Ram