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