-- 修改完成审批时间为业务数据的提报时间（top 1：t_hpdi_bizdatabill对t_hpdi_bizdata是一对多，同一单据编号的多条t_hpdi_bizdata数据都是同一个fsubmitdate，所以取一个即可） (PRJ-00215378) zxm20220823
update t_hpdi_bizdatabill t set fauditdate = (select top 1 fsubmitdate from t_hpdi_bizdata t1 where t1.fapplyno = t.fbillno) where fauditdate is null and exists (select 1 from t_hpdi_bizdata t1 where t1.fapplyno = t.fbillno);