第一步:执行附件(不结帐增加工厂日历SQL脚本.sql)中的语句;
第二步:执行以下语句:
--备份 select * into t_WorkCalendar20200727 from t_WorkCalendar select * into t_Mutiworkcal120200727 from t_Mutiworkcal
--删除 delete from t_WorkCalendar where FDay>'2020-07-01' --其中这个日期已本期第一天为准
delete from t_Mutiworkcal where FDay>'2020-07-01' exec prc_GenWorkCal '2021-12-31'
1