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

浙公网安备 33010602011771号