merge into CT_HOS_Yiyuanflzc a
using (select fl.FNUMBER, cu.FProvince, fl.CFFlqssj,fl.CFFlzzsj
from CT_XZK_Sybyyectjfl fl
inner join T_BD_Customer cu
on cu.fid = fl.CFBasedataID) t
on (a.fnumber = t.FNUMBER)
when matched then
update set a.CFReturnedstart = t.CFFlqssj ,a.CFReturnedend = t.CFFlzzsj
merge into CT_HOS_YiyuanflzcEntry a using(
select * from CT_HOS_Yiyuanflzc
) t on (t.fid=a.FParentID and ( a.CFRebatestart is null or a.CFRebateend is null ) ) when matched then
update set a.CFRebatestart=t.CFReturnedstart, a.CFRebateend = t.CFReturnedend
---批量修改目标终端的单据状态为提交
update CT_XZK_Targetterminal set CFBillstatus='PROCESSED' where FNumber
in(
'MBZD-202102-000029',
'MBZD-202102-000184',
'MBZD-202102-000187',
'MBZD-202102-000190' ,
'MBZD-202102-000191' ,
'MBZD-202102-000192'
)
-----事业部医院二次谈价返利
update CT_XZK_Sybyyectjfl set CFZclx=3 where CFZclx=2
update CT_XZK_Sybyyectjfl set CFZclx=2 where CFZclx=1
--医院返利政策
select * from CT_HOS_Yiyuanflzc where FNUMBER in ( SELECT fnumber FROM CT_XZK_Sybyyectjfl )
-- 修改医院返利政策
update CT_HOS_Yiyuanflzc set CFPOLICYTYPE=3 where CFPOLICYTYPE=2 and FNUMBER in ( SELECT fnumber FROM CT_XZK_Sybyyectjfl )
update CT_HOS_Yiyuanflzc set CFPOLICYTYPE=2 where CFPOLICYTYPE=1 and FNUMBER in ( SELECT fnumber FROM CT_XZK_Sybyyectjfl )
