无锡公司、徐州公司、南昌公司、成都公司、新疆公司数据迁移

1.推荐关系SQL

SELECT * from prm_Agent_Cst_Recommed_141
 where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_141  where ProjCode in 
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID 
in (SELECT ProjGUID from 0221zhenzhoi))
UNION ALL
SELECT * from prm_Agent_Cst_Recommed_142
 where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_142  where ProjCode in 
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID 
in (SELECT ProjGUID from 0221zhenzhoi))
UNION ALL
SELECT * from prm_Agent_Cst_Recommed_143
 where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_143  where ProjCode in 
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID 
in (SELECT ProjGUID from 0221zhenzhoi))
UNION ALL
SELECT * from prm_Agent_Cst_Recommed_144
 where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_144  where ProjCode in 
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID 
in (SELECT ProjGUID from 0221zhenzhoi))
UNION ALL
SELECT * from prm_Agent_Cst_Recommed_145
 where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_145  where ProjCode in 
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID 
in (SELECT ProjGUID from 0221zhenzhoi))
UNION ALL
SELECT * from prm_Agent_Cst_Recommed_146
 where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_146  where ProjCode in 
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID 
in (SELECT ProjGUID from 0221zhenzhoi))
UNION ALL
SELECT * from prm_Agent_Cst_Recommed_147
 where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_147  where ProjCode in 
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID 
in (SELECT ProjGUID from 0221zhenzhoi))
UNION ALL
SELECT * from prm_Agent_Cst_Recommed_148
 where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_148  where ProjCode in 
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID 
in (SELECT ProjGUID from 0221zhenzhoi))
UNION ALL
SELECT * from prm_Agent_Cst_Recommed_149
 where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_149  where ProjCode in 
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID 
in (SELECT ProjGUID from 0221zhenzhoi))
UNION ALL
SELECT * from prm_Agent_Cst_Recommed_150
 where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_150  where ProjCode in 
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID 
in (SELECT ProjGUID from 0221zhenzhoi))
UNION ALL
SELECT * from prm_Agent_Cst_Recommed_151
 where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_151  where ProjCode in 
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID 
in (SELECT ProjGUID from 0221zhenzhoi))

　　2.项目筛选

SELECT * from p_Project where ProjCode in
 ('SZAREA_CSGS.CSCJXY',
'SHAREA_WXGS.WXJYTX',
'SHAREA_WXGS.XCHY',
'SHAREA_WXGS.WXML',
'SZAREA_DGGS.DGWKZT',
'SHAREA_WXGS.WXJY',
'SHAREA_WXGS.P0792',
'SZAREA_DGGS.P0803',
'SZAREA_SZGS.SZSCSA',
'KMGS.KMYSC',
'SZAREA_DGGS.XSLS',
'SZAREA_HNGS.HNGJKTYSZX',
'SZAREA_HZGS.HZSYW',
'SZAREA_NNGS.P0764',
'SZAREA_SZGS.P0837',
'SHAREA_WXGS.P1191',
'SZAREA_CSGS.P0806',
'SZAREA_CSGS.CSWK',
'SZAREA_SZGS.P1051',
'SZAREA_DGGS.DGLRY',
'SZAREA_XMGS.XMWKGC',
'KMGS.MLZC',
'SZAREA_SZGS.GYL',
'SZAREA_DGGS.DGCLS',
'SZAREA_HNGS.HNHBDJGY',
'SZAREA_SZGS.T0014',
'SZAREA_XMGS.XMJYHF',
'CQGS.CQYWN',
'SZAREA_DGGS.DGSHZX',
'SZAREA_CSGS.CSWKJYBJ',
'SHAREA_YZGS.YZJYHF',
'SZAREA_ZHGS.ZHMLZC',
'SHAREA_YZGS.YZWKC',
'SZAREA_SZGS.P0854',
'SZAREA_DGGS.DGJYSH',
'SHAREA_ZJGS.ZJQY',
'TYGS.TYLS',
'SZAREA_FSGS.P0676',
'SHAREA_WXGS.P1304',
'SZAREA_NNGS.P1010',
'CQGS.P0832',
'SZAREA_FZGS.WKGC',
'SZAREA_DGGS.P0385',
'SZAREA_CSGS.CSBLJ',
'SHAREA_HZGS.HZBLJN',
'CQGS.WKXC',
'SZAREA_SZGS.SZTYHY',
'SZAREA_FZGS.MHDXCXMCDK',
'SZAREA_ZSGS.P0848',
'SZAREA_GZGS.P1005',
'SZAREA_FSGS.FSJYZY',
'ZZGS.ZZWKC',
'SZAREA_SZGS.SZYHC',
'SZAREA_ZSGS.JSJY',
'SZAREA_DGGS.P0691',
'XAGS.P1097',
'TYGS.P1098',
'TYGS.P1105',
'CQGS.JSYC',
'SHAREA_WHGS.HSCQHY',
'BJAREA_TSGS.BJTSFH',
'CQGS.CQWKCWX') 
and BUGUID in 
('A1BCC01F-D67A-4D01-BD0E-F736E2D643FD',
'8C7C36B6-71DB-447F-AB7B-E77934B5F32C',
'9C11DB0D-561E-44FF-83D6-E6946BEE1257',
'03FD98C4-0114-4361-998E-D7D3FE32B8EC',
'5A11F323-1BF5-46FF-BFBD-FAA0CACABCD0')

　　3.客户导出

SELECT CstName,	Gender,	BirthDate,	Language,	CstType,	CardType,	CardID,	MobileTel,	
OfficeTel,	HomeTel,	Fax,	Email,	PostCode,	Address,	Nationality,	NativePlace,	
SrcType,	LastModifyTime,	OriGUID,	CreditEvaluate,	CstCode,	Company,	Position,	Incoming,	
CompanyTel,	Race,	Religion,	Political,	IsMerried,	LastTouchTime,	RecentTouch,	LastAssignTime,	
RecentAssign,	LastAppointTime,	RecentAppoint,	
cogniChannel,	Status,	MemGUID,	StaffGUID,	OwnerGUID,	level,	CstGUID
from cst_Customer_141 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_141  where ProjCode in 
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID 
in (SELECT ProjGUID from 0221zhenzhoi));

　　4.跟进导出

SELECT DISTINCT followGUID,	followType,	Description,	
ReceiveDate,	CstGUID,	SrcType	,cstType	,OriCstGUID,	ProjCode,OppGUID 
from cst_FollowRecord_141  
where ProjCode in 
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID 
in (SELECT ProjGUID from 0221zhenzhoi);