笔记24 pivot的使用+动态SQL

笔记24 pivot的使用+动态SQL

--pivot的使用+动态SQL
declare @sql varchar(8000)
select @sql = isnull(@sql + '],[' , '') +ltrim(id) from
(
     select *,row_number() over (partition by [A] order by (select 1)) as id from dbo.testpivot
) t group by id
set @sql = '[' + @sql + ']'
PRINT @sql
exec ('select * from (
select *,row_number() over (partition by [A] order by (select 1)) as id from dbo.testpivot)
a pivot (max(B) for id in (' + @sql + ')) b')