SQLSERVER 列转行

SELECT s.F_SC_YEAR,s.F_SC_JIDU,s.F_SC_GYS,s.F_SC_DJLX, x.zz, x.cgy
FROM (SELECT B.F_SC_YEAR,B.F_SC_JIDU,F_SC_GYS,F_SC_DJLX,F_SC_ZL,F_SC_LJ,F_SC_JS FROM SC_GYSCGYDZ A INNER JOIN SC_GYSCGYDZETY B
ON A.FID = B.FID ) s
CROSS APPLY (
VALUES
('01', F_SC_ZL),
('40', F_SC_LJ),
('50', F_SC_JS)
) x (zz, cgy);