2018-06-21

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

--更新客户等级

update bh20180529.dbo.CustomerAppendInfo set Rating=5 where CustomerID in
( select Now from bh20180502.dbo.CustomerBaseInfoID a inner join YUN_HIS20180521.dbo.H_TMK b on a.Original=b.FID where b.sBJ ='A' )

update bh20180529.dbo.CustomerAppendInfo set Rating=4 where CustomerID in
( select Now from bh20180502.dbo.CustomerBaseInfoID a inner join YUN_HIS20180521.dbo.H_TMK b on a.Original=b.FID where b.sBJ ='B' )

update bh20180529.dbo.CustomerAppendInfo set Rating=3 where CustomerID in
( select Now from bh20180502.dbo.CustomerBaseInfoID a inner join YUN_HIS20180521.dbo.H_TMK b on a.Original=b.FID where b.sBJ ='C' )

update bh20180529.dbo.CustomerAppendInfo set Rating=2 where CustomerID in
( select Now from bh20180502.dbo.CustomerBaseInfoID a inner join YUN_HIS20180521.dbo.H_TMK b on a.Original=b.FID where b.sBJ ='D' )

update bh20180529.dbo.CustomerAppendInfo set Rating=0 where CustomerID in
( select Now from bh20180502.dbo.CustomerBaseInfoID a inner join YUN_HIS20180521.dbo.H_TMK b on a.Original=b.FID where b.sBJ not in ('A','B','C','D') )

 

select sBJ,FID,CardNO from YUN_HIS20180521.dbo.H_TMK where sBJ='A';

--select * from H_TMK;

select * from bh20180529.dbo.CustomerBaseInfoID;
select CustomerID,Rating from bh20180529.dbo.CustomerAppendInfo;