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 test) as a
select @sql = @sql+' into #t from test group by name'
exec(@sql)select * from #t--drop table #t
set @sql = 'select name'
select @sql =@sql + ',sum(case km when '''+km+''' then cj end) ['+km+']'
from (select distinct km from test) as a
select @sql = @sql+' into #t from test group by name'
exec(@sql)select * from #t--drop table #t
set @sql = 'select name'
select @sql =@sql + ',sum(case km when '''+km+''' then cj end) ['+km+']'
from (select distinct km from test) as a
select @sql = @sql+' into ##t from test group by name'
exec(@sql)select * from ##tdrop table ##t
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 test) as a
select @sql = @sql+' from test group by name'
exec(@sql)
谢谢