declare @sql varchar(8000)
set @sql = 'select name'
select @sql = @sql + ',sum(case km when '''+km+''' then cj end) ['+km+']'
from (select distinct km from bbb) as a
select @sql = @sql+' from bbb group by name'
exec(@sql)drop table bbb
set @sql = 'select name'
select @sql = @sql + ',sum(case km when '''+km+''' then cj end) ['+km+']'
from (select distinct km from bbb) as a
select @sql = @sql+' from bbb group by name'
exec(@sql)drop table bbb
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货