https://stackoverflow.com/questions/24470/sql-server-examples-of-pivoting-string...
SELECT S1.no_read, S1.SS1 , S2.SS2 FROM ( --取科目1的 SELECT no_read, score1 SS1...
SELECT t0.[no_read] ,t0.[subject] ,t0.[score1] FROM [MyLab].[dbo]....
CREATE TABLE scroe ( no_read nvarchar(40) NULL , subject nvarchar(40) NULL , sco...