34,838
社区成员




declare @sql varchar(8000)
declare @clounm varchar(20)
declare @tablename varchar(20)
set @sql = 'select Name '
select @sql = @sql + ' , max(case Subject when ''' + @clounm + ''' then Result else 0 end) [' +@clounm + ']' +'from (select distinct'+@clounm+' from'+ @tablename+') as a '
set @sql = @sql + ' from tb group by name'
exec(@sql)
declare @sql varchar(8000)
declare @clounm varchar(20)
declare @tablename varchar(20)
set @sql = 'select Name '
select @sql = @sql + ' , max(case Subject when ''' + @clounm + ''' then Result else 0 end) [' +@clounm + ']'
from (select distinct @clounm from @tablename) as a
set @sql = @sql + ' from tb group by name'
exec(@sql)