Piolot_RepotForm_PeiHao/年度销售额回款额汇总报表yuyubo.sql

 
/*dialect*/SELECT  EE.*
,ee.<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ա AS Salesperson
,[<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>] as XCumulative,[<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] as UsualAlterAmount,[<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>] as SiNO,[<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] as SiNOUsualAlter,[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>] as WuhanPilotThisYear
,[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] as WuhanPilotUsualAlter, [̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>] as Discovery,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>] as HongKongPilot,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>] as HuaXiaYunLian ,[<EFBFBD><EFBFBD>ϸ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>] as DetailArea
,[ZhuhaiPilot]=[<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>]+[<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]
,[PilotSumAmount]=[<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>]+[<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]+[<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>]+[<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]+[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]+[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]+[̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]+[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>]+[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
  ,ROW_NUMBER() OVER (ORDER BY [SBU] ,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID])*10  AS FID
  ,ROW_NUMBER() OVER (ORDER BY [SBU] ,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID])*10  AS FIDENTITYID ,0 AS Sort
  into #TMPBBC038E0063211F0AD6BB7D6383
FROM (
SELECT DISTINCT    
A.* ,[X1Month]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-01-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-02-01 00:00:00') kk
),0) 
,[H1Month]=ISNULL((
SELECT SUM([<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 
AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-01-01 00:00:00' AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-02-01 00:00:00') kk
),0)   ,[X2Month]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-02-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-03-01 00:00:00') kk
),0) 
,[H2Month]=ISNULL((
SELECT SUM([<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 
AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-02-01 00:00:00' AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-03-01 00:00:00') kk
),0)   ,[X3Month]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-03-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-04-01 00:00:00') kk
),0) 
,[H3Month]=ISNULL((
SELECT SUM([<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 
AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-03-01 00:00:00' AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-04-01 00:00:00') kk
),0)   ,[X4Month]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-04-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-05-01 00:00:00') kk
),0) 
,[H4Month]=ISNULL((
SELECT SUM([<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 
AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-04-01 00:00:00' AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-05-01 00:00:00') kk
),0)   ,[X5Month]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-05-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-06-01 00:00:00') kk
),0) 
,[H5Month]=ISNULL((
SELECT SUM([<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 
AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-05-01 00:00:00' AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-06-01 00:00:00') kk
),0)   ,[X6Month]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-06-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-07-01 00:00:00') kk
),0) 
,[H6Month]=ISNULL((
SELECT SUM([<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 
AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-06-01 00:00:00' AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-07-01 00:00:00') kk
),0)   ,[X7Month]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-07-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-08-01 00:00:00') kk
),0) 
,[H7Month]=ISNULL((
SELECT SUM([<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 
AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-07-01 00:00:00' AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-08-01 00:00:00') kk
),0)   ,[X8Month]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-08-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-09-01 00:00:00') kk
),0) 
,[H8Month]=ISNULL((
SELECT SUM([<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 
AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-08-01 00:00:00' AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-09-01 00:00:00') kk
),0)   ,[X9Month]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-09-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-10-01 00:00:00') kk
),0) 
,[H9Month]=ISNULL((
SELECT SUM([<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 
AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-09-01 00:00:00' AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-10-01 00:00:00') kk
),0)   ,[X10Month]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-10-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-11-01 00:00:00') kk
),0) 
,[H10Month]=ISNULL((
SELECT SUM([<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 
AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-10-01 00:00:00' AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-11-01 00:00:00') kk
),0)   ,[X11Month]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-11-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-12-01 00:00:00') kk
),0) 
,[H11Month]=ISNULL((
SELECT SUM([<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 
AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-11-01 00:00:00' AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2025-12-01 00:00:00') kk
),0)   ,[X12Month]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-12-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2026-01-01 00:00:00') kk
),0) 
,[H12Month]=ISNULL((
SELECT SUM([<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 
AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-12-01 00:00:00' AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2026-01-01 00:00:00') kk
),0)  ,[<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>]=ISNULL((
SELECT SUM(<EFBFBD><EFBFBD>̯<EFBFBD><EFBFBD><EFBFBD><EFBFBD>)  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,<EFBFBD><EFBFBD>̯<EFBFBD><EFBFBD><EFBFBD><EFBFBD>  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-01-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2026-01-01 00:00:00') kk
),0) 
,[<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>]=ISNULL((
SELECT SUM([<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD>ۼƵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 
AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-01-01 00:00:00' AND AA.[Ӧ<EFBFBD>յ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2026-01-01 00:00:00') kk
),0)  

,[<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]=ISNULL((SELECT SUM(FBillAllAmount_LC-F_Amountstar)
FROM (
 SELECT FChangeDate,FJoinOrderAmount	,b.FBILLNO, aa.FBillAllAmount_LC,F_Amountstar 
 FROM T_SAL_ORDERFIN aa 
LEFT JOIN  T_SAL_ORDER B
ON aa.FID=b.fid
WHERE   aa.FID IN (SELECT [<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID] FROM [ZZZ_SalesRportShareData] share WITH(NOLOCK)
 WHERE [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-01-01 00:00:00' AND [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2026-01-01 00:00:00' AND share.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=a.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  AND <EFBFBD><EFBFBD>֯ID=100302 ) 
 AND B.FCHANGEDATE >='2025-01-01 00:00:00' AND  B.FCHANGEDATE<'2026-01-01 00:00:00'
) ss),0)
,[<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]   AND <EFBFBD><EFBFBD>֯ID=100303
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-01-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2026-01-01 00:00:00') kk
),0) 
,[<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]=ISNULL((SELECT SUM(FBillAllAmount_LC-F_Amountstar)
FROM (
 SELECT FChangeDate,FJoinOrderAmount	,b.FBILLNO, aa.FBillAllAmount_LC,F_Amountstar 
 FROM T_SAL_ORDERFIN aa 
LEFT JOIN  T_SAL_ORDER B
ON aa.FID=b.fid
WHERE   aa.FID IN (SELECT [<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID] FROM [ZZZ_SalesRportShareData] share WITH(NOLOCK)
 WHERE [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-01-01 00:00:00' AND [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2026-01-01 00:00:00' AND share.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=a.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  AND <EFBFBD><EFBFBD>֯ID=100303 ) 
 AND B.FCHANGEDATE >='2025-01-01 00:00:00' AND  B.FCHANGEDATE<'2026-01-01 00:00:00'
) ss),0)
,[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]   AND <EFBFBD><EFBFBD>֯ID=100305
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-01-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2026-01-01 00:00:00') kk
),0) 
,[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>]=ISNULL((SELECT SUM(FBillAllAmount_LC-F_Amountstar)
FROM (
 SELECT FChangeDate,FJoinOrderAmount	,b.FBILLNO, aa.FBillAllAmount_LC,F_Amountstar 
 FROM T_SAL_ORDERFIN aa 
LEFT JOIN  T_SAL_ORDER B
ON aa.FID=b.fid
WHERE   aa.FID IN (SELECT [<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID] FROM [ZZZ_SalesRportShareData] share WITH(NOLOCK)
 WHERE [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-01-01 00:00:00' AND [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2026-01-01 00:00:00' AND share.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=a.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]  AND <EFBFBD><EFBFBD>֯ID=100305 ) 
 AND B.FCHANGEDATE >='2025-01-01 00:00:00' AND  B.FCHANGEDATE<'2026-01-01 00:00:00'
) ss),0)
,[̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]   AND <EFBFBD><EFBFBD>֯ID=438223
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-01-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2026-01-01 00:00:00') kk
),0) 
,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]   AND <EFBFBD><EFBFBD>֯ID=438224
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-01-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2026-01-01 00:00:00') kk
),0) 
,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]=ISNULL((
SELECT SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>])  FROM (
SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],<EFBFBD><EFBFBD><EFBFBD>۵<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ID,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܶ<EFBFBD>]  
FROM [ZZZ_SalesRportShareData] AA WITH(NOLOCK)  WHERE AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]=A.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]   AND <EFBFBD><EFBFBD>֯ID=533896
AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-01-01 00:00:00' AND AA.[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2026-01-01 00:00:00') kk
),0) 
 FROM  
 (SELECT DISTINCT [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ա] ,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID],[SBU] ,[<EFBFBD><EFBFBD>ϸ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>],<EFBFBD><EFBFBD>֯ID FROM [ZZZ_SalesRportShareData] WITH(NOLOCK)
 WHERE [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] >='2025-01-01 00:00:00' AND [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>] <'2026-01-01 00:00:00'   and 1=1  ) A ) EE
 
 ORDER BY  [SBU] ,[<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] 



  UPDATE #TMPBBC038E0063211F0AD6BB7D6383 SET sbu='<27><><EFBFBD><EFBFBD>' WHERE sbu IS null

 --SELECT  DISTINCT sbu FROM #TMPBBC038E0063211F0AD6BB7D6383



 insert into #TMPBBC038E0063211F0AD6BB7D6383(Salesperson,[<5B><><EFBFBD><EFBFBD>ԱID],SBU,DetailArea,X1Month,H1Month,X2Month,H2Month,X3Month,H3Month,X4Month,H4Month
 ,X5Month,H5Month,X6Month,H6Month
,X7Month, H7Month,X8Month,H8Month,X9Month,H9Month,X10Month,H10Month,X11Month,H11Month,X12Month,H12Month
,[XCumulative],[UsualAlterAmount],[SiNO],[SiNOUsualAlter],[WuhanPilotThisYear],[WuhanPilotUsualAlter],[Discovery],[HongKongPilot],HuaXiaYunLian
,[ZhuhaiPilot],[PilotSumAmount],FID,FIDENTITYID,sort
,[<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>],[<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
,<EFBFBD><EFBFBD>֯ID)
 SELECT [sbu]+'С<EFBFBD><EFBFBD>' , 99383320 ,'','', SUM(X1Month) AS X1Month,SUM(H1Month) AS H1Month, SUM(X2Month) AS X2Month,SUM(H2Month) AS H2Month, SUM(X3Month) AS X3Month,SUM(H3Month) AS H3Month, SUM(X4Month) AS X4Month,SUM(H4Month) AS H4Month
 , SUM(X5Month) AS X5Month,SUM(H5Month) AS H5Month, SUM(X6Month) AS X6Month,SUM(H6Month) AS H6Month, SUM(X7Month) AS X7Month,SUM(H7Month) AS H7Month, SUM(X8Month) AS X8Month, SUM(h8Month) AS h8Month,SUM(X9Month) AS X9Month,SUM(H9Month) AS H9Month
 , SUM(X10Month) AS X10Month,SUM(H10Month) AS H10Month
 , SUM(X11Month) AS X11Month,SUM(H11Month) AS H11Month
 , SUM(X12Month) AS X12Month  , SUM(H12Month) AS H12Month 
 , SUM([XCumulative]) AS [XCumulative], SUM([UsualAlterAmount]) AS [UsualAlterAmount],SUM([SiNO]) AS [SiNO], SUM([SiNOUsualAlter]) AS [SiNOUsualAlter]
 ,SUM([WuhanPilotThisYear]) AS [WuhanPilotThisYear],SUM([WuhanPilotUsualAlter]) AS [WuhanPilotUsualAlter],SUM([Discovery]) AS [Discovery]
 ,SUM([HongKongPilot]) AS [HongKongPilot]
 ,SUM([HuaXiaYunLian]) AS [HuaXiaYunLian],SUM([ZhuhaiPilot]) AS [ZhuhaiPilot],SUM([PilotSumAmount]) AS [PilotSumAmount],MAX(FID)+1 AS FID ,MAX(FIDENTITYID)+1 AS FIDENTITYID ,1 as sort
 ,0 as <EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>, 0 [<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],0 [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
 ,0 [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>], 100302 [<EFBFBD><EFBFBD>֯ID]
 FROM #TMPBBC038E0063211F0AD6BB7D6383
 where [<EFBFBD><EFBFBD>֯ID]=100302
 GROUP BY SBU

 insert into #TMPBBC038E0063211F0AD6BB7D6383(Salesperson,[<5B><><EFBFBD><EFBFBD>ԱID],SBU,DetailArea,X1Month,H1Month,X2Month,H2Month,X3Month,H3Month,X4Month,H4Month
 ,X5Month,H5Month,X6Month,H6Month
,X7Month, H7Month,X8Month,H8Month,X9Month,H9Month,X10Month,H10Month,X11Month,H11Month,X12Month,H12Month
,[XCumulative],[UsualAlterAmount],[SiNO],[SiNOUsualAlter],[WuhanPilotThisYear],[WuhanPilotUsualAlter],[Discovery],[HongKongPilot],HuaXiaYunLian
,[ZhuhaiPilot],[PilotSumAmount],FID,FIDENTITYID,sort
,[<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>],[<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
,<EFBFBD><EFBFBD>֯ID )
 
 SELECT '<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>źϼƣ<EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>+SBU+ŵ<><C5B5><EFBFBD><EFBFBD><EFBFBD><EFBFBD>+<2B><>ҵ<EFBFBD><D2B5>+OEM<45><4D><EFBFBD><EFBFBD><EFBFBD><EFBFBD>+EMT<4D>Ŷ<EFBFBD>+<2B><><EFBFBD><EFBFBD>+<2B><><EFBFBD>ӹ<EFBFBD>˾<EFBFBD><CBBE>' , 99383322 ,'','', SUM(X1Month) AS X1Month,SUM(H1Month) AS H1Month, SUM(X2Month) AS X2Month,SUM(H2Month) AS H2Month, SUM(X3Month) AS X3Month,SUM(H3Month) AS H3Month, SUM(X4Month) AS X4Month,SUM(H4Month) AS H4Month
 , SUM(X5Month) AS X5Month,SUM(H5Month) AS H5Month, SUM(X6Month) AS X6Month,SUM(H6Month) AS H6Month, SUM(X7Month) AS X7Month,SUM(H7Month) AS H7Month, SUM(X8Month) AS X8Month, SUM(h8Month) AS h8Month,SUM(X9Month) AS X9Month,SUM(H9Month) AS H9Month
 , SUM(X10Month) AS X10Month,SUM(H10Month) AS H10Month
 , SUM(X11Month) AS X11Month,SUM(H11Month) AS H11Month
 , SUM(X12Month) AS X12Month  , SUM(H12Month) AS H12Month 
 , SUM([XCumulative]) AS [XCumulative], SUM([UsualAlterAmount]) AS [UsualAlterAmount],SUM([SiNO]) AS [SiNO], SUM([SiNOUsualAlter]) AS [SiNOUsualAlter]
 ,SUM([WuhanPilotThisYear]) AS [WuhanPilotThisYear],SUM([WuhanPilotUsualAlter]) AS [WuhanPilotUsualAlter],SUM([Discovery]) AS [Discovery]
 ,SUM([HongKongPilot]) AS [HongKongPilot]
 ,SUM([HuaXiaYunLian]) AS [HuaXiaYunLian],SUM([ZhuhaiPilot]) AS [ZhuhaiPilot],SUM([PilotSumAmount]) AS [PilotSumAmount],(SELECT MAX(FID) FROM  #TMPBBC038E0063211F0AD6BB7D6383)+1 +1 AS FID ,(SELECT MAX(FID) FROM  #TMPBBC038E0063211F0AD6BB7D6383)+1  AS FIDENTITYID ,1 as sort
 ,0 as <EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>, 0 [<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],SUM([<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>]) [<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],SUM([<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  [<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],SUM([<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>])  [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],SUM([<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],SUM([̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>])  [̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
 ,SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>]) [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>])  [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],100302 as [<EFBFBD><EFBFBD>֯ID]
 FROM #TMPBBC038E0063211F0AD6BB7D6383
 where [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]<99383300 AND <EFBFBD><EFBFBD>֯ID=100302


 UPDATE #TMPBBC038E0063211F0AD6BB7D6383 SET [XCumulative]=(b.[XCumulative]) ,[UsualAlterAmount]=(b.[UsualAlterAmount]),[SiNO]=(b.[SiNO]),[SiNOUsualAlter]=(b.[SiNOUsualAlter]) 
 ,[WuhanPilotThisYear]=(b.[WuhanPilotThisYear]),[WuhanPilotUsualAlter]=(b.[WuhanPilotUsualAlter]),[Discovery]=(b.[Discovery]),[HongKongPilot]=(b.[HongKongPilot]),[HuaXiaYunLian]=(b.[HuaXiaYunLian])
 ,[ZhuhaiPilot]=(b.[ZhuhaiPilot]),[PilotSumAmount]=(b.[PilotSumAmount])
 FROM (SELECT [XCumulative]=SUM(b.[XCumulative]) ,[UsualAlterAmount]=SUM(b.[UsualAlterAmount]),[SiNO]=SUM(b.[SiNO]),[SiNOUsualAlter]=SUM(b.[SiNOUsualAlter]) 
 ,[WuhanPilotThisYear]=SUM(b.[WuhanPilotThisYear]),[WuhanPilotUsualAlter]=SUM(b.[WuhanPilotUsualAlter]),[Discovery]=SUM(b.[Discovery]),[HongKongPilot]=SUM(b.[HongKongPilot]),[HuaXiaYunLian]=SUM(b.[HuaXiaYunLian])
 ,[ZhuhaiPilot]=SUM(b.[ZhuhaiPilot]),[PilotSumAmount]=SUM(b.[PilotSumAmount]) FROM #TMPBBC038E0063211F0AD6BB7D6383 b WITH(NOLOCK) WHERE b.[<5B><><EFBFBD><EFBFBD>ԱID] < 99383300 ) b
 WHERE #TMPBBC038E0063211F0AD6BB7D6383.[<5B><><EFBFBD><EFBFBD>ԱID]=99383322; 

  
 insert into #TMPBBC038E0063211F0AD6BB7D6383(Salesperson,[<5B><><EFBFBD><EFBFBD>ԱID],SBU,DetailArea,X1Month,H1Month,X2Month,H2Month,X3Month,H3Month,X4Month,H4Month
 ,X5Month,H5Month,X6Month,H6Month
,X7Month, H7Month,X8Month,H8Month,X9Month,H9Month,X10Month,H10Month,X11Month,H11Month,X12Month,H12Month
,[XCumulative],[UsualAlterAmount],[SiNO],[SiNOUsualAlter],[WuhanPilotThisYear],[WuhanPilotUsualAlter],[Discovery],[HongKongPilot],HuaXiaYunLian
,[ZhuhaiPilot],[PilotSumAmount],FID,FIDENTITYID,sort
,[<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>],[<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
,<EFBFBD><EFBFBD>֯ID )
  
 SELECT 'һ<EFBFBD><EFBFBD><EFBFBD>麣<EFBFBD><EFBFBD>ŵ<EFBFBD>ϼ<EFBFBD>' , 99383323 ,'','', SUM(X1Month) AS X1Month,SUM(H1Month) AS H1Month, SUM(X2Month) AS X2Month,SUM(H2Month) AS H2Month, SUM(X3Month) AS X3Month,SUM(H3Month) AS H3Month, SUM(X4Month) AS X4Month,SUM(H4Month) AS H4Month
 , SUM(X5Month) AS X5Month,SUM(H5Month) AS H5Month, SUM(X6Month) AS X6Month,SUM(H6Month) AS H6Month, SUM(X7Month) AS X7Month,SUM(H7Month) AS H7Month, SUM(X8Month) AS X8Month, SUM(h8Month) AS h8Month,SUM(X9Month) AS X9Month,SUM(H9Month) AS H9Month
 , SUM(X10Month) AS X10Month,SUM(H10Month) AS H10Month
 , SUM(X11Month) AS X11Month,SUM(H11Month) AS H11Month
 , SUM(X12Month) AS X12Month  , SUM(H12Month) AS H12Month 
, 0 AS [XCumulative], 0 AS [UsualAlterAmount],0 AS [SiNO], 0 AS [SiNOUsualAlter]
 ,0 AS [WuhanPilotThisYear],0 AS [WuhanPilotUsualAlter],0 AS [Discovery]
 ,0 AS [HongKongPilot]
 ,0 AS [HuaXiaYunLian],0 AS [ZhuhaiPilot], 0 AS [PilotSumAmount],(SELECT MAX(FID) FROM  #TMPBBC038E0063211F0AD6BB7D6383)+1 AS FID ,(SELECT MAX(FID) FROM  #TMPBBC038E0063211F0AD6BB7D6383)+1 +1 AS FIDENTITYID ,1 as sort
 ,0 as <EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>, 0 [<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],0 [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
 ,0 [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],100303 as [<EFBFBD><EFBFBD>֯ID]
 FROM #TMPBBC038E0063211F0AD6BB7D6383
 where [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] <99383300  AND <EFBFBD><EFBFBD>֯ID=100303

 
 insert into #TMPBBC038E0063211F0AD6BB7D6383(Salesperson,[<5B><><EFBFBD><EFBFBD>ԱID],SBU,DetailArea,X1Month,H1Month,X2Month,H2Month,X3Month,H3Month,X4Month,H4Month
 ,X5Month,H5Month,X6Month,H6Month
,X7Month, H7Month,X8Month,H8Month,X9Month,H9Month,X10Month,H10Month,X11Month,H11Month,X12Month,H12Month
,[XCumulative],[UsualAlterAmount],[SiNO],[SiNOUsualAlter],[WuhanPilotThisYear],[WuhanPilotUsualAlter],[Discovery],[HongKongPilot],HuaXiaYunLian
,[ZhuhaiPilot],[PilotSumAmount],FID,FIDENTITYID,sort
,[<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>],[<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
,<EFBFBD><EFBFBD>֯ID )
  
 SELECT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>' , 99383324 ,'','', SUM(X1Month) AS X1Month,SUM(H1Month) AS H1Month, SUM(X2Month) AS X2Month,SUM(H2Month) AS H2Month, SUM(X3Month) AS X3Month,SUM(H3Month) AS H3Month, SUM(X4Month) AS X4Month,SUM(H4Month) AS H4Month
 , SUM(X5Month) AS X5Month,SUM(H5Month) AS H5Month, SUM(X6Month) AS X6Month,SUM(H6Month) AS H6Month, SUM(X7Month) AS X7Month,SUM(H7Month) AS H7Month, SUM(X8Month) AS X8Month, SUM(h8Month) AS h8Month,SUM(X9Month) AS X9Month,SUM(H9Month) AS H9Month
 , SUM(X10Month) AS X10Month,SUM(H10Month) AS H10Month
 , SUM(X11Month) AS X11Month,SUM(H11Month) AS H11Month
 , SUM(X12Month) AS X12Month  , SUM(H12Month) AS H12Month 
 , 0 AS [XCumulative], 0 AS [UsualAlterAmount],0 AS [SiNO], 0 AS [SiNOUsualAlter]
 ,0 AS [WuhanPilotThisYear],0 AS [WuhanPilotUsualAlter],0 AS [Discovery]
 ,0 AS [HongKongPilot]
 ,0 AS [HuaXiaYunLian],0 AS [ZhuhaiPilot], 0 AS [PilotSumAmount],(SELECT MAX(FID) FROM  #TMPBBC038E0063211F0AD6BB7D6383)+1 AS FID ,(SELECT MAX(FID) FROM  #TMPBBC038E0063211F0AD6BB7D6383)+1 +1 AS FIDENTITYID ,1 as sort
 ,0 as <EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>, 0 [<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],0 [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
 ,0 [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],533896 as [<EFBFBD><EFBFBD>֯ID]
 FROM #TMPBBC038E0063211F0AD6BB7D6383
 where [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID]!=99383320 AND <EFBFBD><EFBFBD>֯ID=533896

 
 insert into #TMPBBC038E0063211F0AD6BB7D6383(Salesperson,[<5B><><EFBFBD><EFBFBD>ԱID],SBU,DetailArea,X1Month,H1Month,X2Month,H2Month,X3Month,H3Month,X4Month,H4Month
 ,X5Month,H5Month,X6Month,H6Month
,X7Month, H7Month,X8Month,H8Month,X9Month,H9Month,X10Month,H10Month,X11Month,H11Month,X12Month,H12Month
,[XCumulative],[UsualAlterAmount],[SiNO],[SiNOUsualAlter],[WuhanPilotThisYear],[WuhanPilotUsualAlter],[Discovery],[HongKongPilot],HuaXiaYunLian
,[ZhuhaiPilot],[PilotSumAmount],FID,FIDENTITYID,sort
,[<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>],[<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
,<EFBFBD><EFBFBD>֯ID )
  
 SELECT '<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵ<EFBFBD>ϼ<EFBFBD>' , 99383325 ,'','', SUM(X1Month) AS X1Month,SUM(H1Month) AS H1Month, SUM(X2Month) AS X2Month,SUM(H2Month) AS H2Month, SUM(X3Month) AS X3Month,SUM(H3Month) AS H3Month, SUM(X4Month) AS X4Month,SUM(H4Month) AS H4Month
 , SUM(X5Month) AS X5Month,SUM(H5Month) AS H5Month, SUM(X6Month) AS X6Month,SUM(H6Month) AS H6Month, SUM(X7Month) AS X7Month,SUM(H7Month) AS H7Month, SUM(X8Month) AS X8Month, SUM(h8Month) AS h8Month,SUM(X9Month) AS X9Month,SUM(H9Month) AS H9Month
 , SUM(X10Month) AS X10Month,SUM(H10Month) AS H10Month
 , SUM(X11Month) AS X11Month,SUM(H11Month) AS H11Month
 , SUM(X12Month) AS X12Month  , SUM(H12Month) AS H12Month 
 , 0 AS [XCumulative], 0 AS [UsualAlterAmount],0 AS [SiNO], 0 AS [SiNOUsualAlter]
 ,0 AS [WuhanPilotThisYear],0 AS [WuhanPilotUsualAlter],0 AS [Discovery]
 ,0 AS [HongKongPilot]
 ,0 AS [HuaXiaYunLian],0 AS [ZhuhaiPilot], 0 AS [PilotSumAmount],(SELECT MAX(FID) FROM  #TMPBBC038E0063211F0AD6BB7D6383)+1 AS FID ,(SELECT MAX(FID) FROM  #TMPBBC038E0063211F0AD6BB7D6383)+1 +1 AS FIDENTITYID ,1 as sort
 ,0 as <EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>, 0 [<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],0 [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
 ,0 [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],438224 as [<EFBFBD><EFBFBD>֯ID]
 FROM #TMPBBC038E0063211F0AD6BB7D6383
 where [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] <99383300  AND <EFBFBD><EFBFBD>֯ID=438224

 
 
 insert into #TMPBBC038E0063211F0AD6BB7D6383(Salesperson,[<5B><><EFBFBD><EFBFBD>ԱID],SBU,DetailArea,X1Month,H1Month,X2Month,H2Month,X3Month,H3Month,X4Month,H4Month
 ,X5Month,H5Month,X6Month,H6Month
,X7Month, H7Month,X8Month,H8Month,X9Month,H9Month,X10Month,H10Month,X11Month,H11Month,X12Month,H12Month
,[XCumulative],[UsualAlterAmount],[SiNO],[SiNOUsualAlter],[WuhanPilotThisYear],[WuhanPilotUsualAlter],[Discovery],[HongKongPilot],HuaXiaYunLian
,[ZhuhaiPilot],[PilotSumAmount],FID,FIDENTITYID,sort
,[<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>],[<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
,<EFBFBD><EFBFBD>֯ID )
  
 SELECT '<EFBFBD>ġ<EFBFBD>̼<EFBFBD><EFBFBD><EFBFBD>ϼ<EFBFBD>' , 99383326 ,'','', SUM(X1Month) AS X1Month,SUM(H1Month) AS H1Month, SUM(X2Month) AS X2Month,SUM(H2Month) AS H2Month, SUM(X3Month) AS X3Month,SUM(H3Month) AS H3Month, SUM(X4Month) AS X4Month,SUM(H4Month) AS H4Month
 , SUM(X5Month) AS X5Month,SUM(H5Month) AS H5Month, SUM(X6Month) AS X6Month,SUM(H6Month) AS H6Month, SUM(X7Month) AS X7Month,SUM(H7Month) AS H7Month, SUM(X8Month) AS X8Month, SUM(h8Month) AS h8Month,SUM(X9Month) AS X9Month,SUM(H9Month) AS H9Month
 , SUM(X10Month) AS X10Month,SUM(H10Month) AS H10Month
 , SUM(X11Month) AS X11Month,SUM(H11Month) AS H11Month
 , SUM(X12Month) AS X12Month  , SUM(H12Month) AS H12Month 
 , 0 AS [XCumulative], 0 AS [UsualAlterAmount],0 AS [SiNO], 0 AS [SiNOUsualAlter]
 ,0 AS [WuhanPilotThisYear],0 AS [WuhanPilotUsualAlter],0 AS [Discovery]
 ,0 AS [HongKongPilot]
 ,0 AS [HuaXiaYunLian],0 AS [ZhuhaiPilot], 0 AS [PilotSumAmount],(SELECT MAX(FID) FROM  #TMPBBC038E0063211F0AD6BB7D6383)+1 AS FID ,(SELECT MAX(FID) FROM  #TMPBBC038E0063211F0AD6BB7D6383)+1 +1 AS FIDENTITYID ,1 as sort
 ,0 as <EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>, 0 [<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],0 [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
 ,0 [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],438223 as [<EFBFBD><EFBFBD>֯ID]
 FROM #TMPBBC038E0063211F0AD6BB7D6383
 where [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] <99383300  AND <EFBFBD><EFBFBD>֯ID=438223

 
 insert into #TMPBBC038E0063211F0AD6BB7D6383(Salesperson,[<5B><><EFBFBD><EFBFBD>ԱID],SBU,DetailArea,X1Month,H1Month,X2Month,H2Month,X3Month,H3Month,X4Month,H4Month
 ,X5Month,H5Month,X6Month,H6Month
,X7Month, H7Month,X8Month,H8Month,X9Month,H9Month,X10Month,H10Month,X11Month,H11Month,X12Month,H12Month
,[XCumulative],[UsualAlterAmount],[SiNO],[SiNOUsualAlter],[WuhanPilotThisYear],[WuhanPilotUsualAlter],[Discovery],[HongKongPilot],HuaXiaYunLian
,[ZhuhaiPilot],[PilotSumAmount],FID,FIDENTITYID,sort
,[<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>],[<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
,<EFBFBD><EFBFBD>֯ID )
  
 SELECT '<EFBFBD>塢<EFBFBD>人<EFBFBD><EFBFBD>ŵ<EFBFBD>ϼ<EFBFBD>' , 99383327 ,'','', SUM(X1Month) AS X1Month,SUM(H1Month) AS H1Month, SUM(X2Month) AS X2Month,SUM(H2Month) AS H2Month, SUM(X3Month) AS X3Month,SUM(H3Month) AS H3Month, SUM(X4Month) AS X4Month,SUM(H4Month) AS H4Month
 , SUM(X5Month) AS X5Month,SUM(H5Month) AS H5Month, SUM(X6Month) AS X6Month,SUM(H6Month) AS H6Month, SUM(X7Month) AS X7Month,SUM(H7Month) AS H7Month, SUM(X8Month) AS X8Month, SUM(h8Month) AS h8Month,SUM(X9Month) AS X9Month,SUM(H9Month) AS H9Month
 , SUM(X10Month) AS X10Month,SUM(H10Month) AS H10Month
 , SUM(X11Month) AS X11Month,SUM(H11Month) AS H11Month
 , SUM(X12Month) AS X12Month  , SUM(H12Month) AS H12Month 
, 0 AS [XCumulative], 0 AS [UsualAlterAmount],0 AS [SiNO], 0 AS [SiNOUsualAlter]
 ,0 AS [WuhanPilotThisYear],0 AS [WuhanPilotUsualAlter],0 AS [Discovery]
 ,0 AS [HongKongPilot]
 ,0 AS [HuaXiaYunLian],0 AS [ZhuhaiPilot], 0 AS [PilotSumAmount],(SELECT MAX(FID) FROM  #TMPBBC038E0063211F0AD6BB7D6383)+1 AS FID ,(SELECT MAX(FID) FROM  #TMPBBC038E0063211F0AD6BB7D6383)+1 +1 AS FIDENTITYID ,1 as sort
 ,0 as <EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>, 0 [<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],0 [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],0 [̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
 ,0 [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],100305 as [<EFBFBD><EFBFBD>֯ID]
 FROM #TMPBBC038E0063211F0AD6BB7D6383
 where [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] < 99383300 AND <EFBFBD><EFBFBD>֯ID=100305


 
 insert into #TMPBBC038E0063211F0AD6BB7D6383(Salesperson,[<5B><><EFBFBD><EFBFBD>ԱID],SBU,DetailArea,X1Month,H1Month,X2Month,H2Month,X3Month,H3Month,X4Month,H4Month
 ,X5Month,H5Month,X6Month,H6Month
,X7Month, H7Month,X8Month,H8Month,X9Month,H9Month,X10Month,H10Month,X11Month,H11Month,X12Month,H12Month
,[XCumulative],[UsualAlterAmount],[SiNO],[SiNOUsualAlter],[WuhanPilotThisYear],[WuhanPilotUsualAlter],[Discovery],[HongKongPilot],HuaXiaYunLian
,[ZhuhaiPilot],[PilotSumAmount],FID,FIDENTITYID,sort
,[<EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>],[<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],[̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],[<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
,<EFBFBD><EFBFBD>֯ID )
 
 SELECT '<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܼƣ<EFBFBD>һ+<2B><>+<2B><><EFBFBD><EFBFBD>' , 99383328 ,'','', SUM(X1Month) AS X1Month,SUM(H1Month) AS H1Month, SUM(X2Month) AS X2Month,SUM(H2Month) AS H2Month, SUM(X3Month) AS X3Month,SUM(H3Month) AS H3Month, SUM(X4Month) AS X4Month,SUM(H4Month) AS H4Month
 , SUM(X5Month) AS X5Month,SUM(H5Month) AS H5Month, SUM(X6Month) AS X6Month,SUM(H6Month) AS H6Month, SUM(X7Month) AS X7Month,SUM(H7Month) AS H7Month, SUM(X8Month) AS X8Month, SUM(h8Month) AS h8Month,SUM(X9Month) AS X9Month,SUM(H9Month) AS H9Month
 , SUM(X10Month) AS X10Month,SUM(H10Month) AS H10Month
 , SUM(X11Month) AS X11Month,SUM(H11Month) AS H11Month
 , SUM(X12Month) AS X12Month  , SUM(H12Month) AS H12Month 
 , SUM([XCumulative]) AS [XCumulative], SUM([UsualAlterAmount]) AS [UsualAlterAmount],SUM([SiNO]) AS [SiNO], SUM([SiNOUsualAlter]) AS [SiNOUsualAlter]
 ,SUM([WuhanPilotThisYear]) AS [WuhanPilotThisYear],SUM([WuhanPilotUsualAlter]) AS [WuhanPilotUsualAlter],SUM([Discovery]) AS [Discovery]
 ,SUM([HongKongPilot]) AS [HongKongPilot]
 ,SUM([HuaXiaYunLian]) AS [HuaXiaYunLian],SUM([ZhuhaiPilot]) AS [ZhuhaiPilot],SUM([PilotSumAmount]) AS [PilotSumAmount],(SELECT MAX(FID) FROM  #TMPBBC038E0063211F0AD6BB7D6383)+1 +1 AS FID ,(SELECT MAX(FID) FROM  #TMPBBC038E0063211F0AD6BB7D6383)+1  AS FIDENTITYID ,1 as sort
 ,0 as <EFBFBD>ۼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>۶<EFBFBD>, 0 [<EFBFBD>ۼƻؿ<EFBFBD><EFBFBD><EFBFBD>],0 [<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],SUM([<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>]) [<EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],SUM([<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  [<EFBFBD><EFBFBD>ŵ<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],SUM([<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>])  [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],SUM([<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>])  [<EFBFBD>人<EFBFBD><EFBFBD>ŵ-<EFBFBD><EFBFBD><EFBFBD>궩<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>],SUM([̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>])  [̼<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>]
 ,SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>]) [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ŵҵ<EFBFBD><EFBFBD>],SUM([<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>])  [<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>],999999 as [<EFBFBD><EFBFBD>֯ID]
 FROM #TMPBBC038E0063211F0AD6BB7D6383
 where [<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ԱID] IN (99383327,99383326,99383325,99383324,99383323,99383322) 


  --SELECT Salesperson,* FROM #TMPBBC038E0063211F0AD6BB7D6383
  --ORDER BY fid desc

 
 SELECT ROW_NUMBER() OVER (ORDER BY MAX(FID))  FID, Salesperson,SBU,DetailArea,SUM(X1Month) AS X1Month,SUM(H1Month) AS H1Month, SUM(X2Month) AS X2Month,SUM(H2Month) AS H2Month, SUM(X3Month) AS X3Month,SUM(H3Month) AS H3Month, SUM(X4Month) AS X4Month,SUM(H4Month) AS H4Month
 , SUM(X5Month) AS X5Month,SUM(H5Month) AS H5Month, SUM(X6Month) AS X6Month,SUM(H6Month) AS H6Month, SUM(X7Month) AS X7Month,SUM(H7Month) AS H7Month, SUM(X8Month) AS X8Month, SUM(h8Month) AS h8Month,SUM(X9Month) AS X9Month,SUM(H9Month) AS H9Month
 , SUM(X10Month) AS X10Month,SUM(H10Month) AS H10Month
 , SUM(X11Month) AS X11Month,SUM(H11Month) AS H11Month
 , SUM(X12Month) AS X12Month  , SUM(H12Month) AS H12Month 
 , SUM([XCumulative]) AS [XCumulative], SUM([UsualAlterAmount]) AS [UsualAlterAmount],SUM([SiNO]) AS [SiNO], SUM([SiNOUsualAlter]) AS [SiNOUsualAlter]
 ,SUM([WuhanPilotThisYear]) AS [WuhanPilotThisYear],SUM([WuhanPilotUsualAlter]) AS [WuhanPilotUsualAlter],SUM([Discovery]) AS [Discovery]
 ,SUM([HongKongPilot]) AS [HongKongPilot]
 ,SUM([HuaXiaYunLian]) AS [HuaXiaYunLian],SUM([ZhuhaiPilot]) AS [ZhuhaiPilot],SUM([PilotSumAmount]) AS [PilotSumAmount],MAX(FID)  FIDENTITYID,MAX(sort)  sort
  --INTO TMPBBC038E0063211F0AD6BB7D6383
   FROM #TMPBBC038E0063211F0AD6BB7D6383
GROUP BY Salesperson,SBU,DetailArea
ORDER BY FID 

 --DROP TABLE #TMPBBC038E0063211F0AD6BB7D6383

 --drop table TMP545D9CCF0B8411F0AD6BB7D6383

 --SELECT 38743629.200000 -38743629.2000 , 46695875.5500-46562512.130000