2000 动态 行列转换

if object_id('tb')is not null drop table tb

go

create table tb(姓名 varchar(10),课程 varchar(10),分数 int)

insert into tb values('张三','语文',74)

insert into tb values('张三','数学',83)

insert into tb values('张三','物理',93)

insert into tb values('李四','语文',74)

insert into tb values('李四','数学',84)

insert into tb values('李四','物理',94)
go
select * from tb
declare @sql varchar(8000)
select @sql=isnull(@sql+',','')+' max(case 课程 when '''+课程+''' then 分数 else 0 end) ['+课程+']'
from(select distinct 课程 from tb) asa      
set @sql='select 姓名,'+@sql+' from tb group by 姓名'
exec(@sql)