harsha547
4/2/2017 - 6:05 PM

Group Concatenation in SQL SERVER

Group Concatenation in SQL SERVER

-- Group concatenation in SQL SERVER
CREATE TABLE #Players
(
 ID INT,
 Name VARCHAR(25)
);

INSERT INTO #Players VALUES(1,'Harsha');
INSERT INTO #Players VALUES(2,'Rohan');
INSERT INTO #Players VALUES(3,'Neil');

SELECT Name + ',' 
 FROM #Players
 FOR XML PATH('');
 
 -- Linkedin Profile : https://www.linkedin.com/in/harshasannareddy/