COALESCE with DISTINCT in SQLServer

If you want comma separated values from columns it is so simple. Use COALESCE function provided by SQL Server.

DECLARE @csv varchar(max)
select @csv = COALESCE(@csv + ‘,’,”) + cast(id  AS VARCHAR) from tablename
print @csv

COALESCE with DISTINCT Values

If you want, DISTINCT values in COALESCE function use inner table like below.

DECLARE @csv varchar(max)
select @csv = COALESCE(@csv + ‘,’,”) + cast(id  AS VARCHAR) from
(SELECT DISTINCT id FROM TableName)
print @csv

Happy Programming

Advertisement