美国苏州芜湖扬州贵阳福州吉林滑雪事业部南通项目上线

1.buguid

美国	92DA2AB6-7CD8-4B10-ACD1-9FE61801E33B
苏州	07427E83-D461-4FA4-8A62-B7100353A695
芜湖	F6324015-FC20-496A-8F3A-DB414C6C4417
扬州	2F23E50E-88D2-4854-9EFA-6E326BF289CD
贵阳	D5EF5F06-6FFA-4933-8B71-E598E8A09E91
福州	C1C3FF6B-0514-4338-9EF7-421384551FCB
吉林滑雪事业部	59E0F24C-1D20-4E75-878F-213254F21C80
南通	6BFF2A9B-3D1F-4E87-BD2F-76055B8D4209

2.项目

sql

 1 SELECT DISTINCT ProjCode from prm_Agent_Cst_Recommed_141
 2 where ProjCode in (SELECT ProjCode from 0221zhenzhoi)
 3 UNION ALL
 4 SELECT DISTINCT ProjCode from prm_Agent_Cst_Recommed_142
 5 where ProjCode in (SELECT ProjCode from 0221zhenzhoi)
 6 UNION ALL
 7 SELECT DISTINCT ProjCode from prm_Agent_Cst_Recommed_143
 8 where ProjCode in (SELECT ProjCode from 0221zhenzhoi)
 9 UNION ALL
10 SELECT DISTINCT ProjCode from prm_Agent_Cst_Recommed_144
11 where ProjCode in (SELECT ProjCode from 0221zhenzhoi)
12 UNION ALL
13 SELECT DISTINCT ProjCode from prm_Agent_Cst_Recommed_145
14 where ProjCode in (SELECT ProjCode from 0221zhenzhoi)
15 UNION ALL
16 SELECT DISTINCT ProjCode from prm_Agent_Cst_Recommed_146
17 where ProjCode in (SELECT ProjCode from 0221zhenzhoi)
18 UNION ALL
19 SELECT DISTINCT ProjCode from prm_Agent_Cst_Recommed_147
20 where ProjCode in (SELECT ProjCode from 0221zhenzhoi)
21 UNION ALL
22 SELECT DISTINCT ProjCode from prm_Agent_Cst_Recommed_148
23 where ProjCode in (SELECT ProjCode from 0221zhenzhoi)
24 UNION ALL
25 SELECT DISTINCT ProjCode from prm_Agent_Cst_Recommed_149
26 where ProjCode in (SELECT ProjCode from 0221zhenzhoi)
27 UNION ALL
28 SELECT DISTINCT ProjCode from prm_Agent_Cst_Recommed_150
29 where ProjCode in (SELECT ProjCode from 0221zhenzhoi)
30 UNION ALL
31 SELECT DISTINCT ProjCode from prm_Agent_Cst_Recommed_151
32 where ProjCode in (SELECT ProjCode from 0221zhenzhoi)

View Code

projcode

 1 SZAREA_FZGS.P1157
 2 SZAREA_FZGS.FZJYZY
 3 SZAREA_FZGS.WKGC
 4 SZAREA_FZGS.P1060
 5 SZAREA_FZGS.FZJY
 6 SZAREA_FZGS.PTWKC
 7 SZAREA_FZGS.MHDXCXMCDK
 8 SHAREA_YZGS.YZWKC
 9 SHAREA_YZGS.P1081
10 SHAREA_YZGS.YZJYHF
11 SHAREA_WHGS.HSCQHY
12 SHAREA_WHGS.WHWKCNQ
13 SZAREA_FZGS.FZWKC

View Code

3.查询

跟进导出

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);




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



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



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



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



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



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



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



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



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



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

View Code

客户导出

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));

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_142 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_142  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));

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_143 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_143  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));

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_144 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_144  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));

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_145 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_145  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));

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_146 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_146  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));

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_147 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_147  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));

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_148 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_148  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));

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_149 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_149  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));

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_150 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_150  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));

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_151 a where CstGUID in  (SELECT DISTINCT CstGUID
from cst_FollowRecord_151  where ProjCode in
(SELECT ProjCode from 0221zhenzhoi)
or ProjGUID
in (SELECT ProjGUID from 0221zhenzhoi));

posted @ 2016-05-26 18:02 侠之大者kamil 阅读(104) 评论(0) 收藏举报

刷新页面返回顶部

侠之大者

美国 苏州 芜湖 扬州 贵阳 福州 吉林滑雪事业部 南通 项目上线

1.buguid

2.项目

sql

projcode

3.查询

公告

美国苏州芜湖扬州贵阳福州吉林滑雪事业部南通项目上线