解决方案：

【适用版本】

通用

【分析处理】

--备份数据

select * into attendancefile0526 from t_hr_ats_attendancefile

select * into attendancefilehis0526 from t_hr_ats_attendancefilehis

select * into holidaylimit0526 from t_hr_ats_holidaylimit

select * into holidaylimitdetail0526 from t_hr_ats_holidaylimitdetail

select * into overtimebillentry0526 from  t_hr_ats_overtimebillentry

select * into overtimebill0526 from  t_hr_ats_overtimebill 

select * into punchcardrecord0526 from t_hr_ats_punchcardrecord

--删除数据

delete from  t_hr_ats_holidaylimit where fproposerid='3ZPLMWP7RVW6EnlHElwGi4Dvfe0='

delete from t_hr_ats_holidaylimitdetail where fproposerid='3ZPLMWP7RVW6EnlHElwGi4Dvfe0='

delete from t_hr_ats_overtimebill where fid in( select fbillid from t_hr_ats_overtimebillentry where fpersonid='3ZPLMWP7RVW6EnlHElwGi4Dvfe0=')

delete from  t_hr_ats_overtimebillentry where fpersonid='3ZPLMWP7RVW6EnlHElwGi4Dvfe0='

delete from t_hr_ats_punchcardrecord  where fproposerid='3ZPLMWP7RVW6EnlHElwGi4Dvfe0='

delete from t_hr_ats_attendancefile where fproposerid='3ZPLMWP7RVW6EnlHElwGi4Dvfe0=' 

delete from t_hr_ats_attendancefilehis where fproposerid='3ZPLMWP7RVW6EnlHElwGi4Dvfe0='