删除某员工考勤业务数据的参考脚本

解决方案：

【适用版本】

通用

【分析处理】

--备份数据

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