生成透视列之COALESCE

临时表#t，数据如下：

 

实现如下数据：

方法一：

declare @sql0 varchar(MAX)
select @sql0 = isnull(@sql0 + '],[' , '') + Province from #t group by Province
set @sql0 = '[' + @sql0 + ']'
print @sql0

 

方法二：

DECLARE @PivotColHeader VARCHAR(MAX)
SELECT @PivotColHeader = COALESCE(@PivotColHeader + ',[' + cast(Province as varchar) + ']','[' + cast(Province as varchar) + ']')
FROM #t GROUP BY Province
print @PivotColHeader