原始数据:
Select Distinct 地区 From 客户
方法一:
select STUFF((SELECT Distinct ','+地区
FROM 客户 FOR XML PATH(''))
,1,1,space(0)) as 地区
方法二:
declare @Str varchar(200)
select @Str = isnull(@Str + ',' , '' ) + isnull(地区 , '' )
from (Select Distinct 地区 from 客户) AS Region
select @Str as 地区