Sql Server 列转行（多字段）

列转行，多个字段

SELECT * FROM dbo.AATest;

  

 

SELECT Code,Value

FROM

(SELECT * FROM AATest) p

UNPIVOT ( Code FOR x1 IN (code1, code2) )AS UnA

UNPIVOT ( Value FOR x2 IN (Value1,value2) )AS UnB

WHERE RIGHT(x1, 1) = RIGHT(x2, 1)

结果演示