declare @s varchar(8000)
set @s=''
select @s=@s+',['+rtrim(Country)+']=max(case Country when '''+Country+''' then Score else 0 end)' from 原表 group by Country
set @s = 'select PlayerID,Name_J'@s+' from 原表 group by PlayerID,Name_J'
exec(@s)
set @s=''
select @s=@s+',['+rtrim(Country)+']=max(case Country when '''+Country+''' then Score else 0 end)' from 原表 group by Country
set @s = 'select PlayerID,Name_J'@s+' from 原表 group by PlayerID,Name_J'
exec(@s)
--应该是 libin_ftsafe(子陌红尘) 那个动态SQL!
set @s='select PlayerID,Name_J'
select @s=@s+','+Country+'=max(case when Country='''+Country+''' then Score else 0 end)'
from 表
group by Country
set @s=@s+' from 表 group by PlayerID,Name_J'
exec(@s)