declare @sql varcahr(3000)
set @sql=''
set @sql =@sql +',sum(case when 请求类型 ='''+请求类型+''' then 数量 end) as ' + 请求类型 from (select distinct 请求类型 from tbQQSL ) aa
exec ('select '营业部' as 请求类型 '+ @sql from tbQQSL ')
set @sql=''
set @sql =@sql +',sum(case when 请求类型 ='''+请求类型+''' then 数量 end) as ' + 请求类型 from (select distinct 请求类型 from tbQQSL ) aa
exec ('select '营业部' as 请求类型 '+ @sql from tbQQSL ')
,sum(case 请求类型 when '03' then 数量 end) as [03]
,sum(case 请求类型 when '04' then 数量 end) as [04]
,sum(case 请求类型 when '05' then 数量 end) as [05]
from tbQQSL
请求类型
营业部
select '营业部' as 请求类型
,sum(case 请求类型 when '02' then 数量 end) as [02]
,sum(case 请求类型 when '03' then 数量 end) as [03]
,sum(case 请求类型 when '04' then 数量 end) as [04]
,sum(case 请求类型 when '05' then 数量 end) as [05]
from tbQQSL
,sum(case 请求类型 when '02' then 数量 end) as [02]
,sum(case 请求类型 when '03' then 数量 end) as [03]
,sum(case 请求类型 when '04' then 数量 end) as [04]
,sum(case 请求类型 when '05' then 数量 end) as [05]
from tbQQSL
set @sql='select ''营业部'' as 请求类型'
select @sql=@sql+char(13)+
',sum(case 请求类型 when '''+请求类型+'02'' then 数量 end) as ['+请求类型+']'
from(select distinct 请求类型 from tbQQSL) a
set @sql=@sql+char(13)+'from tbQQSL'
exec (@sql)