--SQL2000
d eclare @s varchar(1000)
select @s=isnull(@s+',','')+ltrim(id) from #tb
select @s
--SQL2005
select stuff((select ','+ltrim(id) from #tb for xml path('')),1,1,'')
d eclare @s varchar(1000)
select @s=isnull(@s+',','')+ltrim(id) from #tb
select @s
--SQL2005
select stuff((select ','+ltrim(id) from #tb for xml path('')),1,1,'')