34,576
社区成员
发帖
与我相关
我的任务
分享
declare @sql varchar(8000)
set @sql = 'select kemu_id as ' + 'kemu_name'
select @sql = @sql + ' , sum(max(case ry when ''' + ry + ''' then je else 0 end)) [' + ry + ']'
from (select distinct ry from #fy) as a
set @sql = @sql + ',sum(isnull(je,0)) as Hj from #fy group by kemu_id order by kemu_id,ry'
exec(@sql)
declare @sql varchar(8000)
set @sql = 'select kemu_id as ' + 'kemu_name'
select @sql = @sql + ' , max(case ry when ''' + ry + ''' then je else 0 end) [' + ry + ']'
from (select distinct ry from #fy) as a
set @sql = @sql + ',sum(isnull(je,0)) as Hj from #fy group by kemu_id order by kemu_id'
exec(@sql)
set @sql = @sql + ',sum(isnull(je,0)) as Hj from #fy group by kemu_id,ry order by kemu_id,ry'
===》》
set @sql = @sql + ',sum(isnull(je,0)) as Hj from #fy group by kemu_id order by kemu_id'
declare @sql varchar(8000)
set @sql = 'select kemu_id as ' + 'kemu_name'
select @sql = @sql + ' , max(case ry when ''' + ry + ''' then je else 0 end) [' + ry + ']'
from (select distinct ry from #fy) as a
set @sql = @sql + ',sum(isnull(je,0)) as Hj from #fy group by kemu_id order by kemu_id'
exec(@sql)