--列转换行UNPIVOT
SELECT * FROM
(SELECT A.*,B.DEPT,B.SECTION,B.LZ,B.LZ_DATE
FROM GC_DWT_OA.IMP_EMP_SCHEDULE_LIST A
RIGHT JOIN GC_DWT_OA.IMP_EMPLOYEE_DEPT B ON A.USER_ID=B.USER_ID
WHERE 1 = 1
AND A.USER_ID IN ('A0002719','A0002277','A0002245','A0002218')
AND B.DEPT='MFG'
AND ATTENDANCE_PERIOD='202310'
)A
UNPIVOT INCLUDE NULLS (Value FOR Attribute IN
(DATE26,DATE27,DATE28,DATE29,DATE30,DATE31,DATE01,DATE02,DATE03,DATE04,DATE05,DATE06,DATE07,DATE08,DATE09,DATE10,DATE11,DATE12,
DATE13,DATE14,DATE15,DATE16,DATE17,DATE18,DATE19,DATE20,DATE21,DATE22,DATE23,DATE24,DATE25))