[适用版本]

8.2SP2

[解决方案]

问题:后台批量禁用考勤档案

处理方案:

select * into T_HR_ATS_AttendanceFile_bk from T_HR_ATS_AttendanceFile

update T_HR_ATS_AttendanceFile set FATTENDFILESTATE =2 where FATTENDFILESTATE =1 and FPROPOSERID in(select FPERSONID from T_HR_PersonPosition where FLEFTDATE <={ts '2018-09-30'})