22,209
社区成员
发帖
与我相关
我的任务
分享
declare @sql varchar(8000)
select @sql=isnull(@sql+',','')+'sum(case when proname='''+proname+''' then pronumber else 0 end)
as ['+proname+']' from tbname group by proname
exec('select id,'+@sql+' from tbname group by id')
select id,
sum(case when proname='kk' then pronumber else 0 end) as 'kk',
sum(case when proname='bb' then pronumber else 0 end) as 'bb',
sum(case when proname='ll' then pronumber else 0 end) as 'll'
from tbname
group by id