16,556
社区成员
发帖
与我相关
我的任务
分享
declare @sql varchar(8000)
set @sql = 'select Person '
select @sql = @sql + ' , max(case item when ''' + item + ''' then qty else 0 end) [' + item + ']'
from (select distinct item from TableName) as a
set @sql = @sql + ' from TableName group by Person'
exec(@sql)
--通过动态构建@sql,得到如下脚本
select Person as Person ,
max(case item when 'b' then qty else 0 end) b,
max(case item when 'c' then qty else 0 end) c,
max(case item when 'd' then qty else 0 end) d,
max(case item when 'e' then qty else 0 end) d
from TableName
group by Person