当需要行轉列的列名不確定或者過多時,可使用動態的行轉列方式進行轉換,效果對比圖如下:
=======>
下面為具體的步驟:
-----1.原數據
create table #Score
(
sno varchar(30),
coursename varchar(30),
score varchar(30),
)
insert into #Score values('1000','語文','85')
insert into #Score values('1000','數學','82')
insert into #Score values('1000','英語','89')
insert into #Score values('1000','化學','88')
insert into #Score values('1000','物理','80')
insert into #Score values('1001','語文','82')