sql语句之多列转换成多行(cross apply用法)

原数据:

sql语句之多列转换成多行(cross apply用法)

实现以下效果:

sql语句之多列转换成多行(cross apply用法)

sql语句:

SELECT playday,fee
FROM [dbo].[CM_Contract] 
cross apply
(
    values
        ([FirstAmount],[PalnDay1]),
        ([SecondAmount],[PalnDay2]),
        ([ThirdAmount],[PalnDay3])
)c(fee,playday)
where playday is not null