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

解决方案：

【适用版本】通用
【操作步骤】
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  = '')