DECLARE @STR VARCHAR(8000)
set @STR=''
SELECT @STR=@STR+ISNULL(',','')+rtrim(a1) FROM (SELECT DISTINCT(a1)
FROM TableName)AS T
SELECT @STR
DECLARE @STR VARCHAR(8000)
set @STR=''
SELECT @STR=@STR+ISNULL(',','')+rtrim(a1) FROM (SELECT DISTINCT(a1)
FROM TableName)AS T
SELECT @STR