declare @sql varchar(8000)
set @sql = 'select s2,'select @sql = @sql + 'sum(case s1 when '''+s1+'''
then s3 else 0 end) as '''+s1+''','
from (select distinct s1 from 如有下表) as aselect @sql = left(@sql,len(@sql)-1) + ' from 如有下表 group by s2'exec(@sql)
go
set @sql = 'select s2,'select @sql = @sql + 'sum(case s1 when '''+s1+'''
then s3 else 0 end) as '''+s1+''','
from (select distinct s1 from 如有下表) as aselect @sql = left(@sql,len(@sql)-1) + ' from 如有下表 group by s2'exec(@sql)
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货