员工离职，考勤明细还显示该员工数据，如何删除

栏目：s-hr cloud知识作者：金蝶来源：金蝶云社区发布：2024-09-22浏览：1

解决方案：

【适用版本】通用
【操作步骤】
sql语句参考： select * into T_hr_ats_attendanceresult0601 from T_hr_ats_attendanceresult --备份 select * from T_hr_ats_attendanceresult where FATTENCEDATE between {ts '2018-04-27'} and {ts '2018-05-16'} and fproposerid in (select fid from T_bd_person where FNUMBER = '') --改成需要的时间和人员编码 delete from T_hr_ats_attendanceresult where FATTENCEDATE between {ts '2018-04-27'} and {ts '2018-05-16'} and fproposerid in (select fid from T_bd_person where FNUMBER = '')