2018-06-27

2018 年 6 月 27 日2018 年 6 月 27 日 by 沧海之树 In 工作

with t
as
(
select a.FID,a.CardNO,a.JSR,a.jsID,b.Now as cusid,c.CustomerID as jsrid from YUN_HIS20180622.dbo.H_TMK a inner join bh20180529.dbo.CustomerBaseInfoID b
on a.FID=b.Original
inner join bh20180529.dbo.MemberCardHandle c on a.jsID=c.MemberCardNum
where a.JSR is not NULL and a.jsID is not NULL and len(a.jsID)>0
)
--更新来院方式为转介绍

update CustomerBaseInfo set PresentationMode=1 where ID in (select cusid from t)

-- 更新介绍人信息
update a set ReferralsID=t.jsrid from CustomerAppendInfo a inner join t on t.cusid=a.CustomerID