Comma separated values without using For XML Path.
The
easiest way to get all values of a column as comma separated values and use it
in some query is as follow:
Create a table with name and age field and insert some
values:
CREATE TABLE #tmp
(NAME
VARCHAR(255
),Age
INT)INSERT INTO
#tmp
(NAME
,
Age
)SELECT
'Mack',23
UNION ALL SELECT 'Shankey' ,25
UNION ALLSELECT 'Maverick',26
Executing query to fetch comma separated names from the
table
DECLARE @commaSeparated
VARCHAR(MAX)SET @commaSeparated
= ''SELECT @commaSeparated
= name
+ ',' + @commaSeparated
FROM #tmp
SELECT @commaSeparated
PRINT SUBSTRING(@commaSeparated
,0
,LEN(@commaSeparated
))
Output

