declare @output varchar(8000)
select @output=coalesce(@output,'')+ Convert(varchar(50),CityId)+','
from AreMSCrm_ChannelDistributionByCity_Temp
select @output=substring(@output,1,len(@output)-1)
print @output
转载于:https://www.cnblogs.com/lmy213/archive/2012/07/01/2572039.html