Archive

Posts Tagged ‘DISTINCT’

COALESCE with DISTINCT in SQLServer

November 6, 2012 Leave a comment

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

Hope it helps!