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
原数据:
实现以下效果:
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