2018-07-03~2018-07-04

2018 年 7 月 4 日2018 年 7 月 4 日 by 沧海之树 In 工作

select * from CustomerBaseInfo where ID='UVE3ABQ3MR'

select * from MemberCardHandle where CustomerID='UVE3ABQ3MR'
select * from MemberCardInfo where CustomerID='UVE3ABQ3MR'

update MemberCardInfo set MemberCardNum='18052812' where CustomerID='UVE3ABQ3MR'

exec sp_executesql N'SELECT [t4].[Age], (
SELECT COUNT(*)
FROM (
SELECT NULL AS [EMPTY]
FROM [dbo].[CustomerComeLog] AS [t13]
WHERE [t13].[CustomerID] = [t4].[ID]
) AS [t14]
) AS [ComeCount],
(CASE
WHEN [t4].[LastestConsultingItem] IS NOT NULL THEN [t5].[Name]
ELSE CONVERT(NVarChar(50),@p13)
END) AS [ConsultingItem], [t4].[IsCome] AS [cs], [t4].[ID] AS [CustomerID], [t6].[Status] AS [cs2], [t7].[Success] AS [ss], [t4].[FirstComeDate],
(CASE
WHEN [t4].[FirstConsultingItem] IS NOT NULL THEN [t8].[Name]
ELSE CONVERT(NVarChar(50),@p14)
END) AS [FirstConsultingItem],
(CASE
WHEN [t4].[ReferralsID] IS NOT NULL THEN 1
ELSE 0
END) AS [ISReferral], [t4].[LastestComeDate], [t4].[LastestTrackDate],
(CASE
WHEN [t4].[MemberCardNum] IS NULL THEN NULL
ELSE (
SELECT [t17].[NewRankID]
FROM (
SELECT [t16].[NewRankID]
FROM (
SELECT [t15].[NewRankID], [t15].[Valid]
FROM [dbo].[MemberCardHandle] AS [t15]
WHERE [t15].[CustomerID] = [t4].[ID]
) AS [t16]
WHERE [t16].[Valid] = 1
) AS [t17]
)
END) AS [MemberCardLevelID], [t4].[MemberCardNum], [t4].[Name], [t4].[Rating], [t9].[Region], [t4].[RegisterDate], [t4].[BirthDay] AS [BirthDate],
(CASE
WHEN [t4].[SceneEmployee] IS NOT NULL THEN [t10].[Name]
ELSE CONVERT(NVarChar(20),@p15)
END) AS [SceneEmployeeName], [t4].[Sex],
(CASE
WHEN [t4].[TMKEmployee] IS NOT NULL THEN [t11].[Name]
ELSE CONVERT(NVarChar(20),@p16)
END) AS [TmkEmployeeName],
(CASE
WHEN [t4].[UnderstandWayID] IS NULL THEN CONVERT(NVarChar(20),@p17)
ELSE [t12].[UnderstandWayName]
END) AS [UnderstandWay], [t4].[VIP] AS [Vip], [t4].[Address], [t4].[Amount], [t4].[Balance], [t4].[ChannelEmployee], [t4].[CIdentity], [t4].[ComeTimes], [t4].[PresentationPeopleID], [t4].[RegionID], [t4].[CustomerServiceEmployee], [t4].[UnderstandWayID], [t4].[DoctorEmployee], [t4].[EducationID], [t4].[Email], [t4].[SceneEmployee], [t4].[TMKEmployee], [t4].[TempEmployee], [t4].[FirstPhone], [t4].[Forzen], [t4].[HasMedical], [t4].[HasSickHistory], [t4].[IntegrationBalance], [t4].[IsMember], [t4].[LastestOperateEmployee], [t4].[MSN], [t4].[NetChannelID], [t4].[OtherInfo], [t4].[PresentationInsideID], [t4].[PresentationMode], [t4].[PresentationOutsideID], [t4].[ProfessionID], [t4].[QQ], [t4].[RankID], [t4].[Remark], [t4].[Remove], [t4].[RowVersion], [t4].[SecondPhone], [t4].[Status], [t4].[Success], [t4].[SuccessTimes], [t4].[ThirdPhone], [t4].[ZipCode]
FROM (
SELECT [t3].[ID], [t3].[Address], [t3].[Age], [t3].[Amount], [t3].[Balance], [t3].[BirthDay], [t3].[ChannelEmployee], [t3].[CIdentity], [t3].[ComeTimes], [t3].[PresentationPeopleID], [t3].[RegionID], [t3].[CustomerServiceEmployee], [t3].[UnderstandWayID], [t3].[DoctorEmployee], [t3].[EducationID], [t3].[Email], [t3].[SceneEmployee], [t3].[TMKEmployee], [t3].[TempEmployee], [t3].[FirstPhone], [t3].[Forzen], [t3].[HasMedical], [t3].[HasSickHistory], [t3].[IntegrationBalance], [t3].[IsCome], [t3].[IsMember], [t3].[LastestOperateEmployee], [t3].[MSN], [t3].[Name], [t3].[NetChannelID], [t3].[OtherInfo], [t3].[PresentationInsideID], [t3].[PresentationMode], [t3].[PresentationOutsideID], [t3].[ProfessionID], [t3].[QQ], [t3].[RankID], [t3].[RegisterDate], [t3].[Remark], [t3].[Remove], [t3].[RowVersion], [t3].[SecondPhone], [t3].[Sex], [t3].[Status], [t3].[Success], [t3].[SuccessTimes], [t3].[ThirdPhone], [t3].[VIP], [t3].[ZipCode], [t3].[LastestConsultingItem], [t3].[FirstConsultingItem], [t3].[ROW_NUMBER], [t3].[FirstComeDate], [t3].[ReferralsID], [t3].[LastestComeDate], [t3].[LastestTrackDate], [t3].[MemberCardNum], [t3].[Rating]
FROM (
SELECT ROW_NUMBER() OVER (ORDER BY [t0].[ID], [t0].[Address], [t0].[Age], [t0].[Amount], [t0].[Balance], [t0].[BirthDay], [t0].[ChannelEmployee], [t0].[CIdentity], [t0].[ComeTimes], [t0].[PresentationPeopleID], [t0].[RegionID], [t0].[CustomerServiceEmployee], [t0].[UnderstandWayID], [t0].[DoctorEmployee], [t0].[EducationID], [t0].[Email], [t0].[SceneEmployee], [t0].[TMKEmployee], [t0].[TempEmployee], [t0].[FirstPhone], [t0].[Forzen], [t0].[HasMedical], [t0].[HasSickHistory], [t0].[IntegrationBalance], [t0].[IsCome], [t0].[IsMember], [t0].[LastestOperateEmployee], [t0].[MSN], [t0].[Name], [t0].[NetChannelID], [t0].[OtherInfo], [t0].[PresentationInsideID], [t0].[PresentationMode], [t0].[PresentationOutsideID], [t0].[ProfessionID], [t0].[QQ], [t0].[RankID], [t0].[RegisterDate], [t0].[Remark], [t0].[Remove], [t0].[RowVersion], [t0].[SecondPhone], [t0].[Sex], [t0].[Status], [t0].[Success], [t0].[SuccessTimes], [t0].[ThirdPhone], [t0].[VIP], [t0].[ZipCode]) AS [ROW_NUMBER], [t0].[ID], [t0].[Address], [t0].[Age], [t0].[Amount], [t0].[Balance], [t0].[BirthDay], [t0].[ChannelEmployee], [t0].[CIdentity], [t0].[ComeTimes], [t0].[PresentationPeopleID], [t0].[RegionID], [t0].[CustomerServiceEmployee], [t0].[UnderstandWayID], [t0].[DoctorEmployee], [t0].[EducationID], [t0].[Email], [t0].[SceneEmployee], [t0].[TMKEmployee], [t0].[TempEmployee], [t0].[FirstPhone], [t0].[Forzen], [t0].[HasMedical], [t0].[HasSickHistory], [t0].[IntegrationBalance], [t0].[IsCome], [t0].[IsMember], [t0].[LastestOperateEmployee], [t0].[MSN], [t0].[Name], [t0].[NetChannelID], [t0].[OtherInfo], [t0].[PresentationInsideID], [t0].[PresentationMode], [t0].[PresentationOutsideID], [t0].[ProfessionID], [t0].[QQ], [t0].[RankID], [t0].[RegisterDate], [t0].[Remark], [t0].[Remove], [t0].[RowVersion], [t0].[SecondPhone], [t0].[Sex], [t0].[Status], [t0].[Success], [t0].[SuccessTimes], [t0].[ThirdPhone], [t0].[VIP], [t0].[ZipCode], [t2].[LastestConsultingItem], [t2].[FirstConsultingItem], [t2].[FirstComeDate], [t2].[ReferralsID], [t2].[LastestComeDate], [t2].[LastestTrackDate], [t1].[MemberCardNum], [t2].[Rating]
FROM [dbo].[CustomerBaseInfo] AS [t0]
LEFT OUTER JOIN [dbo].[MemberCardInfo] AS [t1] ON [t1].[CustomerID] = [t0].[ID]
LEFT OUTER JOIN [dbo].[CustomerAppendInfo] AS [t2] ON [t2].[CustomerID] = [t0].[ID]
WHERE ((
(CASE
WHEN @p0 = 1 THEN
(CASE
WHEN ([t1].[MemberCardNum] IS NOT NULL) AND ([t1].[MemberCardNum] LIKE @p1) THEN 1
WHEN NOT (([t1].[MemberCardNum] IS NOT NULL) AND ([t1].[MemberCardNum] LIKE @p1)) THEN 0
ELSE NULL
END)
WHEN [t1].[MemberCardNum] IS NOT NULL THEN CONVERT(Int,
(CASE
WHEN [t1].[MemberCardNum] LIKE @p2 THEN 1
WHEN NOT ([t1].[MemberCardNum] LIKE @p2) THEN 0
ELSE NULL
END))
ELSE @p3
END)) = 1) AND ([t0].[Name] LIKE @p4) AND (NOT ([t0].[Remove] = 1)) AND ((CONVERT(TinyInt,[t2].[Rating])) IN (@p5, @p6, @p7, @p8, @p9, @p10))
) AS [t3]
WHERE [t3].[ROW_NUMBER] BETWEEN @p11 + 1 AND @p11 + @p12
) AS [t4]
LEFT OUTER JOIN [dbo].[ItemForConsultingCategory] AS [t5] ON [t5].[ID] = [t4].[LastestConsultingItem]
LEFT OUTER JOIN [dbo].[StatusOfCustomer] AS [t6] ON [t6].[CustomerID] = [t4].[ID]
LEFT OUTER JOIN [dbo].[SuccessOfCustomer] AS [t7] ON [t7].[CustomerID] = [t4].[ID]
LEFT OUTER JOIN [dbo].[ItemForConsultingCategory] AS [t8] ON [t8].[ID] = [t4].[FirstConsultingItem]
LEFT OUTER JOIN [dbo].[CustomerRegion] AS [t9] ON [t9].[ID] = [t4].[RegionID]
LEFT OUTER JOIN [dbo].[Employee] AS [t10] ON [t10].[ID] = [t4].[SceneEmployee]
LEFT OUTER JOIN [dbo].[Employee] AS [t11] ON [t11].[ID] = [t4].[TMKEmployee]
LEFT OUTER JOIN [dbo].[CustomerUnderstandWay] AS [t12] ON [t12].[ID] = [t4].[UnderstandWayID]
ORDER BY [t4].[ROW_NUMBER]',N'@p0 int,@p1 varchar(8000),@p2 varchar(8000),@p3 int,@p4 nvarchar(4000),@p5 tinyint,@p6 tinyint,@p7 tinyint,@p8 tinyint,@p9 tinyint,@p10 tinyint,@p11 int,@p12 int,@p13 nvarchar(4000),@p14 nvarchar(4000),@p15 nvarchar(4000),@p16 nvarchar(4000),@p17 nvarchar(4000)',@p0=1,@p1='%18052812%',@p2='%18052812%',@p3=1,@p4=N'%%',@p5=0,@p6=1,@p7=2,@p8=3,@p9=4,@p10=5,@p11=0,@p12=100,@p13=N'',@p14=N'',@p15=N'',@p16=N'',@p17=N''

select * from MemberCardHandle where CustomerID in
(
'XH45AAMCTD',
'PO6MC8N3Y8',
'S6RLKI5HYI',
'LGBYPISSDX',
'7CHBYONXGB',
'REQI4NTNFM',
'RKBWWNRXVY',
'383TGL41A6',
'X7QRU2QN5P')

select * from MemberCardHandle where CustomerID='G6GGNX9MBE'

select * from MemberCardHandle where MemberCardNum='18051316'

delete from MemberCardHandle where MemberCardNum='18051316'

select * from MemberCardInfo where CustomerID='G6GGNX9MBE'
update MemberCardInfo set MemberCardNum='17051316' where CustomerID='G6GGNX9MBE'

with t
as
(
select * from MemberCardHandle where MemberCardNum not in(select a.MemberCardNum from MemberCardInfo a inner join MemberCardHandle b on
a.CustomerID=b.CustomerID and a.MemberCardNum=b.MemberCardNum)
)
--select * from MemberCardInfo a inner join t on a.CustomerID=t.CustomerID
update a set MemberCardNum=t.MemberCardNum,CardNo='111111' from MemberCardInfo a inner join t on a.CustomerID=t.CustomerID

select * from MemberCardInfo where CustomerID='O1IGA94TIF'

select * from MemberCardHandle where MemberCardNum not in (select MemberCardNum from MemberCardInfo)

select * from MemberCardInfo where MemberCardNum not in (select MemberCardNum from MemberCardHandle)

select * from CustomerBaseInfoID where Now='G6GGNX9MBE'

select * from YUN_HIS20180703.dbo.H_TMK where FID='JZ170513004'

select * from CustomerBaseInfo a inner join MemberCardHandle b on a.ID=b.CustomerID
where b.MemberCardNum='17051316'
select * from CustomerBaseInfo a inner join MemberCardHandle b on a.ID=b.CustomerID
where b.MemberCardNum='18051316'

select * from YUN_HIS20180703.dbo.H_TMK where CardNO='17051316'

select * from MemberCardInfo where MemberCardNum='17051316'

select * from MemberCardInfo where MemberCardNum='18051316'

select * from bh20180529.dbo.MemberCardInfo
select * from bh20180529.dbo.MemberCardHandle

select * from MemberCardInfo where CustomerID in
(
'XH45AAMCTD',
'PO6MC8N3Y8',
'S6RLKI5HYI',
'LGBYPISSDX',
'7CHBYONXGB',
'REQI4NTNFM',
'RKBWWNRXVY',
'383TGL41A6',
'X7QRU2QN5P')

select * from CustomerBaseInfo where ID in
(
'XH45AAMCTD',
'PO6MC8N3Y8',
'S6RLKI5HYI',
'LGBYPISSDX',
'7CHBYONXGB',
'REQI4NTNFM',
'RKBWWNRXVY',
'383TGL41A6',
'X7QRU2QN5P')

select * from CustomerPhoneNumber where CustomerID in
(
'XH45AAMCTD',
'PO6MC8N3Y8',
'S6RLKI5HYI',
'LGBYPISSDX',
'7CHBYONXGB',
'REQI4NTNFM',
'RKBWWNRXVY',
'383TGL41A6',
'X7QRU2QN5P')

select * from YUN_HIS20180703.dbo.H_TMK where FID in
('JZ180420114',
'JZ180420115',
'JZ180420116',
'JZ180420117',
'JZ180420118',
'JZ180420119',
'JZ180521032',
'JZ180521034',
'JZ180521033')

select * from CustomerBaseInfo where ID not in (select CustomerID from CustomerPhoneNumber)

with t
as
(
select FirstPhone as pn,ID as id ,0 as bl,0 as cs,0 as ss,'2018-07-03' as rd,'00001' as hb,'2018-07-03' as lut from CustomerBaseInfo where ID not in (select CustomerID from CustomerPhoneNumber) and len(FirstPhone)>7
)
--select * from CustomerPhoneNumber where PhoneNumber in (select pn from t)
insert into CustomerPhoneNumber(PhoneNumber,CustomerID,Belong,CallStatus,SmsStatus,RegisterDate,Handleby,LastestUpdateTime) (select pn,id,bl,cs,ss,rd,hb,lut from t where pn not in ('15862851451',
'15051268502',
'13814608096',
'13584607229',
'13962981285',
'18761738546',
'15190999922',
'13222109617',
'13361855550',
'18260512812',
'15851219577',
'15250652472',
'15152887194',
'18795705625',
'13605195873',
'13615207332',
'85231601',
'18260513953',
'15370668711',
'13901488172',
'13912281960',
'18651303750',
'13815206363',
'13809089124',
'15162781166',
'3773616123',
'18291802502',
'18705143966',
'15962940990',
'13382362861',
'18557545688',
'3773618335',
'15806352992',
'8962795714',
'17602581530',
'00000010001'))

select * from

select * from CustomerBaseInfo where FirstPhone='15962947768'

select * from CustomerPhoneNumber where PhoneNumber='13815206363'

select * from CustomerBaseInfo where FirstPhone like '%13815206363%'

select * from CustomerPhoneNumber a inner join CustomerBaseInfo b on a.CustomerID=b.ID
where

select * from CustomerPhoneNumber where CustomerID='0DZDZYD7DG'

select * from CustomerBaseInfo where ID='0DZDZYD7DG'
select * from CustomerBaseInfo where ID='ARCYMRG49R'
ARCYMRG49R

select * from CustomerBaseInfoID where Now='0DZDZYD7DG'
select * from CustomerBaseInfoID where Now='ARCYMRG49R'

select * from YUN_HIS20180703.dbo.H_TMK where FID='XC171103101'
select * from YUN_HIS20180703.dbo.H_TMK where FID='XC150614016'

exec sp_executesql N'SELECT [t2].[ID], [t2].[Address], [t2].[Age], [t2].[Amount], [t2].[Balance], [t2].[BirthDay], [t2].[ChannelEmployee], [t2].[CIdentity], [t2].[ComeTimes], [t2].[PresentationPeopleID], [t2].[ProfessionID], [t2].[RegionID], [t2].[CustomerServiceEmployee], [t2].[UnderstandWayID], [t2].[DoctorEmployee], [t2].[EducationID], [t2].[Email], [t2].[SceneEmployee], [t2].[TMKEmployee], [t2].[TempEmployee], [t2].[FirstPhone], [t2].[Forzen], [t2].[HasMedical], [t2].[HasSickHistory], [t2].[IntegrationBalance], [t2].[IsCome], [t2].[IsMember], [t2].[LastestOperateEmployee], [t2].[MSN], [t2].[Name], [t2].[NetChannelID], [t2].[OtherInfo], [t2].[PresentationInsideID], [t2].[PresentationMode], [t2].[PresentationOutsideID], [t2].[QQ], [t2].[RankID], [t2].[RegisterDate], [t2].[Remark], [t2].[Remove], [t2].[RowVersion], [t2].[SecondPhone], [t2].[Sex], [t2].[Status], [t2].[Success], [t2].[SuccessTimes], [t2].[ThirdPhone], [t2].[VIP], [t2].[ZipCode], [t0].[ID] AS [ID2], [t5].[Name] AS [LastestConsultingItem], [t3].[MemberCardNum], [t0].[PlanRVDate] AS [PlanTrackDate],
(CASE
WHEN [t2].[SceneEmployee] IS NOT NULL THEN CONVERT(NVarChar(MAX),[t6].[Name])
ELSE NULL
END) AS [SceneName], [t0].[Remark] AS [Subject],
(CASE
WHEN [t0].[TrackerDept] IS NOT NULL THEN CONVERT(NVarChar(MAX),[t7].[Name])
ELSE NULL
END) AS [TrackDeptName],
(CASE
WHEN [t0].[Tracker] IS NOT NULL THEN CONVERT(NVarChar(MAX),[t8].[Name])
ELSE NULL
END) AS [Tracker], [t9].[Name] AS [TrackName]
FROM [dbo].[WaitReturnVisitCustomer] AS [t0]
INNER JOIN [dbo].[WaitReturnVisitCustomerInfo] AS [t1] ON [t1].[ID] = [t0].[WrvInfoID]
INNER JOIN [dbo].[CustomerBaseInfo] AS [t2] ON [t2].[ID] = [t1].[CustomerID]
LEFT OUTER JOIN [dbo].[MemberCardInfo] AS [t3] ON [t3].[CustomerID] = [t2].[ID]
LEFT OUTER JOIN [dbo].[CustomerAppendInfo] AS [t4] ON [t4].[CustomerID] = [t2].[ID]
LEFT OUTER JOIN [dbo].[ItemForConsultingCategory] AS [t5] ON [t5].[ID] = [t4].[LastestConsultingItem]
LEFT OUTER JOIN [dbo].[Employee] AS [t6] ON [t6].[ID] = [t2].[SceneEmployee]
LEFT OUTER JOIN [dbo].[Department] AS [t7] ON [t7].[ID] = [t0].[TrackerDept]
LEFT OUTER JOIN [dbo].[Employee] AS [t8] ON [t8].[ID] = [t0].[Tracker]
INNER JOIN [dbo].[ReturnVisitItem] AS [t9] ON [t9].[ID] = [t1].[ReturnVisitItemID]
WHERE ([t0].[Tracker] = @p0) AND ([t0].[PlanRVDate] >= @p1) AND ([t0].[PlanRVDate] < @p2) AND ([t2].[Name] LIKE @p3) AND ((
(CASE
WHEN @p4 = 1 THEN
(CASE
WHEN ([t3].[MemberCardNum] IS NOT NULL) AND ([t3].[MemberCardNum] LIKE @p5) THEN 1
WHEN NOT (([t3].[MemberCardNum] IS NOT NULL) AND ([t3].[MemberCardNum] LIKE @p5)) THEN 0
ELSE NULL
END)
WHEN [t3].[MemberCardNum] IS NOT NULL THEN CONVERT(Int,
(CASE
WHEN [t3].[MemberCardNum] LIKE @p6 THEN 1
WHEN NOT ([t3].[MemberCardNum] LIKE @p6) THEN 0
ELSE NULL
END))
ELSE @p7
END)) = 1) AND (([t0].[Status] = @p8) OR ([t0].[Status] = @p9)) AND (NOT ([t2].[Forzen] = 1))',N'@p0 varchar(8000),@p1 date,@p2 date,@p3 nvarchar(4000),@p4 int,@p5 varchar(8000),@p6 varchar(8000),@p7 int,@p8 int,@p9 int',@p0='00178',@p1='2017-07-03',@p2='2018-07-04',@p3=N'%%',@p4=0,@p5='%%',@p6='%%',@p7=1,@p8=0,@p9=3

exec sp_executesql N'SELECT [t1].[ID], [t1].[Address], [t1].[Age], [t1].[Amount], [t1].[Balance], [t1].[BirthDay], [t1].[ChannelEmployee], [t1].[CIdentity], [t1].[ComeTimes], [t1].[PresentationPeopleID], [t1].[ProfessionID], [t1].[RegionID], [t1].[CustomerServiceEmployee], [t1].[UnderstandWayID], [t1].[DoctorEmployee], [t1].[EducationID], [t1].[Email], [t1].[SceneEmployee], [t1].[TMKEmployee], [t1].[TempEmployee], [t1].[FirstPhone], [t1].[Forzen], [t1].[HasMedical], [t1].[HasSickHistory], [t1].[IntegrationBalance], [t1].[IsCome], [t1].[IsMember], [t1].[LastestOperateEmployee], [t1].[MSN], [t1].[Name], [t1].[NetChannelID], [t1].[OtherInfo], [t1].[PresentationInsideID], [t1].[PresentationMode], [t1].[PresentationOutsideID], [t1].[QQ], [t1].[RankID], [t1].[RegisterDate], [t1].[Remark], [t1].[Remove], [t1].[RowVersion], [t1].[SecondPhone], [t1].[Sex], [t1].[Status], [t1].[Success], [t1].[SuccessTimes], [t1].[ThirdPhone], [t1].[VIP], [t1].[ZipCode], [t0].[ID] AS [ID2], [t4].[Name] AS [LastestConsultingItem], [t2].[MemberCardNum], [t0].[PlanTrackDate],
(CASE
WHEN [t1].[SceneEmployee] IS NOT NULL THEN CONVERT(NVarChar(MAX),[t5].[Name])
ELSE NULL
END) AS [SceneName], [t0].[Remark] AS [Subject],
(CASE
WHEN [t0].[TrackerDept] IS NOT NULL THEN CONVERT(NVarChar(MAX),[t6].[Name])
ELSE NULL
END) AS [TrackDeptName],
(CASE
WHEN [t0].[Tracker] IS NOT NULL THEN CONVERT(NVarChar(MAX),[t7].[Name])
ELSE NULL
END) AS [Tracker], [t8].[TrackName]
FROM [dbo].[WaitTrackCustomer] AS [t0]
INNER JOIN [dbo].[CustomerBaseInfo] AS [t1] ON [t1].[ID] = [t0].[CustomerID]
LEFT OUTER JOIN [dbo].[MemberCardInfo] AS [t2] ON [t2].[CustomerID] = [t1].[ID]
LEFT OUTER JOIN [dbo].[CustomerAppendInfo] AS [t3] ON [t3].[CustomerID] = [t1].[ID]
LEFT OUTER JOIN [dbo].[ItemForConsultingCategory] AS [t4] ON [t4].[ID] = [t3].[LastestConsultingItem]
LEFT OUTER JOIN [dbo].[Employee] AS [t5] ON [t5].[ID] = [t1].[SceneEmployee]
LEFT OUTER JOIN [dbo].[Department] AS [t6] ON [t6].[ID] = [t0].[TrackerDept]
LEFT OUTER JOIN [dbo].[Employee] AS [t7] ON [t7].[ID] = [t0].[Tracker]
INNER JOIN [dbo].[TrackInfo] AS [t8] ON [t8].[ID] = [t0].[TrackInfoID]
WHERE ([t0].[Tracker] = @p0) AND ([t0].[PlanTrackDate] >= @p1) AND ([t0].[PlanTrackDate] < @p2) AND ([t1].[Name] LIKE @p3) AND ((
(CASE
WHEN @p4 = 1 THEN
(CASE
WHEN ([t2].[MemberCardNum] IS NOT NULL) AND ([t2].[MemberCardNum] LIKE @p5) THEN 1
WHEN NOT (([t2].[MemberCardNum] IS NOT NULL) AND ([t2].[MemberCardNum] LIKE @p5)) THEN 0
ELSE NULL
END)
WHEN [t2].[MemberCardNum] IS NOT NULL THEN CONVERT(Int,
(CASE
WHEN [t2].[MemberCardNum] LIKE @p6 THEN 1
WHEN NOT ([t2].[MemberCardNum] LIKE @p6) THEN 0
ELSE NULL
END))
ELSE @p7
END)) = 1) AND (([t0].[Status] = @p8) OR ([t0].[Status] = @p9)) AND (NOT ([t1].[Forzen] = 1))',N'@p0 varchar(8000),@p1 date,@p2 date,@p3 nvarchar(4000),@p4 int,@p5 varchar(8000),@p6 varchar(8000),@p7 int,@p8 int,@p9 int',@p0='00178',@p1='2018-05-03',@p2='2018-07-04',@p3=N'%%',@p4=0,@p5='%%',@p6='%%',@p7=1,@p8=0,@p9=3

select * from WaitTrackCustomer where Status='0'

with t
as(
select convert(char(10),dgzDT,120) as plandate,sFID,c.Now,b.bExec as sstatus from YUN_HIS20180622.dbo.H_TMK_GZ b
inner join bh20180529.dbo.CustomerBaseInfoID c on c.Original=b.sFID
)
--select count(*) from bh20180529.dbo.WaitTrackCustomer a inner join t on a.PlanTrackDate=t.plandate and a.CustomerID=t.Now
update a set Status=sstatus from bh20180529.dbo.WaitTrackCustomer a inner join t on a.PlanTrackDate=t.plandate and a.CustomerID=t.Now

select * from MemberCardHandle where MemberCardNum='18041120'

select * from WaitTrackCustomer where CustomerID='O0KU1EVMKG'

select * from UpdateManage

update UpdateManage set NEW_VERSION='56'

select * from CustomerPhoneNumber where PhoneNumber='15997959583'

select * from CustomerBaseInfo where ID='FY77AP72IY'

select * from MemberCardHandle where CustomerID='FY77AP72IY'

select * from MemberCardHandle where MemberCardNum='17032719'

select * from CustomerBaseInfo where ID='MK4W8HP8ZS'

select * from JZ140611039

select * from WaitTrackCustomer where CustomerID='MK4W8HP8ZS' order by PlanTrackDate
select * from YUN_HIS20180622.dbo.H_TMK_GZ where sFID='JZ140611039' order by dgzDT

update bh20180529.dbo.WaitTrackCustomer set Remark=REPLACE(Remark,'结果:',' 结果:') where ID=12624234

select max(len(Remark)) from WaitTrackCustomer

select * from bh20180529.dbo.WaitTrackCustomer where ID=12624234

问题:提醒[水氧活肤][单次]结果: