时间: 2021-08-11 12:13:40,381
  线程ID: 21
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[20753543-3e88-4c4a-b2f1-ef1e769b9849]
FROM [##617bc130efb0466b975e71adec9218cd]
ORDER BY Goods_no


    时间: 2021-08-11 15:14:11,261
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 A.Vip AS [卡号]
, CAST(NULL AS DECIMAL(30,2)) AS [期初积分]
, CAST(NULL AS DECIMAL(30,2)) AS [本期积分]
, CAST(NULL AS DECIMAL(30,2)) AS [消费积分]
, CAST(NULL AS DECIMAL(30,2)) AS [抵减积分]
, CAST(NULL AS DECIMAL(30,2)) AS [金额充值赠送]
, CAST(NULL AS DECIMAL(30,2)) AS [增提积分]
, CAST(NULL AS DECIMAL(30,2)) AS [积分换购]
, CAST(NULL AS DECIMAL(30,2)) AS [积分转入]
, CAST(NULL AS DECIMAL(30,2)) AS [积分转出]
, CAST(NULL AS DECIMAL(30,2)) AS [零售订单积分]
, CAST(NULL AS DECIMAL(30,2)) AS [可用积分]
, CAST(NULL AS DECIMAL(30,2)) AS [累计积分]
, CAST(NULL AS DECIMAL(30,2)) AS [当前积分]
INTO [##5bebd522c3954d599a703dc65cc0ba17]
FROM CustomerVip A


    时间: 2021-08-11 15:14:11,269
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: EXEC p_VipGetIntegral 
@VipTable = '##4e13084e2e794f2ca62c44634b1b0d6d', 
@EndDate = '2020/11/30', 
@DataTable = '##50a7834f77fb40ef97a51431fa8d17cc' 


    时间: 2021-08-11 15:14:11,632
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##5bebd522c3954d599a703dc65cc0ba17 ([卡号], [期初积分])
SELECT A.VIP, SUM(A.IntegralAmount)
FROM ##50a7834f77fb40ef97a51431fa8d17cc A
GROUP BY A.VIP


    时间: 2021-08-11 15:14:11,635
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##5bebd522c3954d599a703dc65cc0ba17 ([卡号], [金额充值赠送])
SELECT A.Vip, SUM(A.Integral)
FROM VIPAddValue A
WHERE A.Posted = 1
AND  A.VipAddValue_Date>='2020/12/1' AND A.VipAddValue_Date<='2021/8/11 23:59:59'
AND EXISTS(SELECT 1 FROM ##4e13084e2e794f2ca62c44634b1b0d6d WHERE VIP=A.VIP) 
GROUP BY A.VIP


    时间: 2021-08-11 15:14:11,645
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT Vip INTO ##5c93c2c925fc466880b9a9e0ef08b36e FROM ##4e13084e2e794f2ca62c44634b1b0d6d

    时间: 2021-08-11 15:14:11,647
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: EXEC p_VipGetIntegral 
@VipTable = '##5c93c2c925fc466880b9a9e0ef08b36e', 
@DataTable = '##5bfacb014f0f432dad3a97ff77897926', 
@IsUsabeIntegral = 1 


    时间: 2021-08-11 15:14:11,901
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##5bebd522c3954d599a703dc65cc0ba17 ([卡号], [可用积分], [当前积分])
SELECT A.VIP, SUM(A.IntegralAmount), SUM(A.Integral)
FROM ##5bfacb014f0f432dad3a97ff77897926 A
GROUP BY A.VIP


    时间: 2021-08-11 15:14:11,907
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##5bebd522c3954d599a703dc65cc0ba17 ([卡号], [消费积分])
SELECT A.Vip_Card, SUM(A.IntegralAmount) 
FROM [vn_Check] A
WHERE A.Posted = 1
AND  A.CheckDate>='2020/12/1' AND A.CheckDate<='2021/8/11 23:59:59'
AND EXISTS(SELECT 1 FROM ##4e13084e2e794f2ca62c44634b1b0d6d WHERE VIP=A.Vip_Card) 
GROUP BY A.Vip_Card


    时间: 2021-08-11 15:14:12,001
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##5bebd522c3954d599a703dc65cc0ba17 ([卡号], [增提积分])
SELECT A.VIP, SUM(A.Integral)
FROM [VIPAddIntegral] A
WHERE A.Posted = 1
AND  A.VipAddIntegral_Date>='2020/12/1' AND A.VipAddIntegral_Date<='2021/8/11 23:59:59'
AND EXISTS(SELECT 1 FROM ##4e13084e2e794f2ca62c44634b1b0d6d WHERE VIP=A.VIP) 
GROUP BY A.VIP, A.VipAddIntegralID, A.VipAddIntegral_Date


    时间: 2021-08-11 15:14:12,029
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##5bebd522c3954d599a703dc65cc0ba17 ([卡号], [积分换购])
SELECT A.VIP, SUM(A.Amount)
FROM [VipIntegralExchange] A
WHERE A.Posted = 1
AND  A.ExchangeDate>='2020/12/1' AND A.ExchangeDate<='2021/8/11 23:59:59'
AND EXISTS(SELECT 1 FROM ##4e13084e2e794f2ca62c44634b1b0d6d WHERE VIP=A.VIP) 
GROUP BY A.VIP


    时间: 2021-08-11 15:14:12,039
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##5bebd522c3954d599a703dc65cc0ba17 ([卡号], [抵减积分])
SELECT A.Vip_Card, SUM(B.Integral)
FROM [vn_Check] A
INNER JOIN CheckCounteractIntegral B ON A.CheckId=B.CheckId
WHERE A.Posted = 1
AND A.CheckDate>='2020/12/1' AND A.CheckDate<='2021/8/11 23:59:59'
AND EXISTS(SELECT 1 FROM ##4e13084e2e794f2ca62c44634b1b0d6d WHERE VIP=A.Vip_Card) 
GROUP BY A.Vip_Card


    时间: 2021-08-11 15:14:12,149
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##5bebd522c3954d599a703dc65cc0ba17 ([卡号], [积分转入])
SELECT A.TurnInCard, SUM(A.TurnInIntegral)
FROM [IntegralTurnCard] A
WHERE A.Posted = 1
AND  A.IntegralTurnCard_Date>='2020/12/1' AND A.IntegralTurnCard_Date<='2021/8/11 23:59:59'
AND EXISTS(SELECT 1 FROM ##4e13084e2e794f2ca62c44634b1b0d6d WHERE VIP=A.TurnInCard) 
GROUP BY A.TurnInCard


    时间: 2021-08-11 15:14:12,158
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##5bebd522c3954d599a703dc65cc0ba17 ([卡号], [积分转出])
SELECT A.TurnOutCard, SUM(A.TurnInIntegral)
FROM [IntegralTurnCard] A
WHERE A.Posted = 1
AND  A.IntegralTurnCard_Date>='2020/12/1' AND A.IntegralTurnCard_Date<='2021/8/11 23:59:59'
AND EXISTS(SELECT 1 FROM ##4e13084e2e794f2ca62c44634b1b0d6d WHERE VIP=A.TurnOutCard) 
GROUP BY A.TurnOutCard


    时间: 2021-08-11 15:14:12,167
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##5bebd522c3954d599a703dc65cc0ba17 ([卡号], [零售订单积分])
SELECT A.VIP, SUM(A.Integral)
FROM [KS2_RetailOrderIntegral] A
WHERE 1 = 1
AND  A.InputTime>='2020/12/1' AND A.InputTime<='2021/8/11 23:59:59'
AND EXISTS(SELECT 1 FROM ##4e13084e2e794f2ca62c44634b1b0d6d WHERE VIP=A.VIP) 
GROUP BY A.VIP


    时间: 2021-08-11 15:14:12,181
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5bebd522c3954d599a703dc65cc0ba17 SET [本期积分] = ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0)


    时间: 2021-08-11 15:14:12,185
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5bebd522c3954d599a703dc65cc0ba17 SET [累计积分] = ISNULL([期初积分],0) + ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0) + ISNULL([积分转入],0) - ISNULL([积分转出],0) + ISNULL([零售订单积分],0)


    时间: 2021-08-11 15:14:12,195
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,Vip.VIP AS [VIP卡号], CV.Name AS [Vip姓名], SUM(期初积分) AS [期初积分], SUM(消费积分) AS [销售积分#消费积分], SUM(增提积分) AS [销售积分#增提积分], SUM(抵减积分) AS [销售积分#抵减积分], SUM(积分换购) AS [销售积分#积分换购], SUM(金额充值赠送) AS [销售积分#金额充值赠送], SUM(本期积分) AS [销售积分#本期积分], SUM(积分转入) AS [积分转入], SUM(积分转出) AS [积分转出], SUM(零售订单积分) AS [零售订单积分], SUM(可用积分) AS [可用积分], SUM(累计积分) AS [累计积分], CASE WHEN ISNULL(SUM([累计积分]),0) = 0 THEN 0 ELSE CAST(SUM([本期积分]) / SUM([累计积分]) AS NUMERIC(18,2)) END AS [占比], SUM(当前积分) AS [当前积分] 
   INTO tempdb.dbo.[4ab21de5-c6dc-41cc-993a-0ac8712c0716] 
 FROM [##4e13084e2e794f2ca62c44634b1b0d6d] Vip
 LEFT JOIN [##5bebd522c3954d599a703dc65cc0ba17] A ON Vip.VIP=A.[卡号]
 LEFT JOIN CustomerVIP CV ON Vip.VIP=CV.VIP
 LEFT JOIN Customer CV1 ON CV.Customer_ID=CV1.Customer_ID
GROUP BY  Vip.VIP, CV.Name
HAVING 1=1
ORDER BY  Vip.VIP, CV.Name


    时间: 2021-08-11 15:16:40,082
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  SELECT IDENTITY(INT, 1, 1) AS RowNumber,   A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], A.CheckDate AS [核销日期], MAX(a.TotalQuantity) AS [销售数量], SUM(a.VipQuantity) AS [会员消费数量], CAST( (CASE WHEN ISNULL(MAX(A.TotalQuantity), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipQuantity), 0)/MAX(A.TotalQuantity) END)  AS Numeric(18, 4)) AS [会员消费数占比], CAST( (CASE WHEN ISNULL(MAX(A.TotalDpAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipDpAmount), 0)/MAX(A.TotalDpAmount) END)  AS Numeric(18, 4)) AS [会员消费吊牌额占比], MAX(a.TotalDpAmount) AS [吊牌额], SUM(a.VipDpAmount) AS [会员吊牌额], MAX(A.TotalAmount) AS [生意额], SUM(A.VIPAmount) AS [会员消费额], CAST( (CASE WHEN ISNULL(MAX(A.TotalAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VIPAmount), 0)/MAX(A.TotalAmount) END)  AS Numeric(18, 4)) AS [会员消费额占比]
 INTO tempdb.dbo.[021de08b-27c7-4ced-9121-6ba957671116]
FROM ##3e5ff7fce5cf4daf95592eccd8d40249 A 
INNER JOIN Customer CT on CT.Customer_ID=A.Customer_ID
LEFT JOIN customervip Vip on Vip.VIP=A.VIP_Card

GROUP BY  A.Customer_ID, CT.Abbrev, A.CheckDate

ORDER BY  A.Customer_ID, CT.Abbrev, A.CheckDate


    时间: 2021-08-11 15:16:56,203
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  SELECT IDENTITY(INT, 1, 1) AS RowNumber,   A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], A.CheckDate AS [核销日期], MAX(a.TotalQuantity) AS [销售数量], SUM(a.VipQuantity) AS [会员消费数量], CAST( (CASE WHEN ISNULL(MAX(A.TotalQuantity), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipQuantity), 0)/MAX(A.TotalQuantity) END)  AS Numeric(18, 4)) AS [会员消费数占比], CAST( (CASE WHEN ISNULL(MAX(A.TotalDpAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipDpAmount), 0)/MAX(A.TotalDpAmount) END)  AS Numeric(18, 4)) AS [会员消费吊牌额占比], MAX(a.TotalDpAmount) AS [吊牌额], SUM(a.VipDpAmount) AS [会员吊牌额], MAX(A.TotalAmount) AS [生意额], SUM(A.VIPAmount) AS [会员消费额], CAST( (CASE WHEN ISNULL(MAX(A.TotalAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VIPAmount), 0)/MAX(A.TotalAmount) END)  AS Numeric(18, 4)) AS [会员消费额占比]
 INTO tempdb.dbo.[021de08b-27c7-4ced-9121-6ba957671116]
FROM ##fa1bba65ddf34d9c8af385d28115b386 A 
INNER JOIN Customer CT on CT.Customer_ID=A.Customer_ID
LEFT JOIN customervip Vip on Vip.VIP=A.VIP_Card

GROUP BY  A.Customer_ID, CT.Abbrev, A.CheckDate

ORDER BY  A.Customer_ID, CT.Abbrev, A.CheckDate


    时间: 2021-08-11 15:18:15,589
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.* 
 INTO ##a38edbc9374647258f50b04d818d4e7c
 FROM CustomerVIP A
 WHERE 1=1 
 AND EXISTS(SELECT 1 FROM ##b01d33d4cb014728a82766f7b5a7bf09 B WHERE B.[VIP]=A.VIP) 
AND A.[ExpireDate]>GETDATE()


    时间: 2021-08-11 15:18:15,644
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.VIP_Card, B.Goods_No, C.ColorId, CAST('' AS VARCHAR(20)) AS Color
,SUM(ISNULL(C.[S1], 0)) AS Quantity 
,SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS DiscountAmount 
INTO ##00a93a6621fd42a7b93da37f1d79628b
FROM [Check] A
INNER JOIN CheckGoods B ON A.CheckID=B.CheckID
INNER JOIN CheckDetail C ON C.CheckGoodsID=B.CheckGoodsID
WHERE A.Posted=1
AND EXISTS(SELECT 1 FROM ##a38edbc9374647258f50b04d818d4e7c WHERE VIP=A.VIP_Card) 
AND A.CheckDate>='2021/6/23' 
AND A.CheckDate<='2021/7/23' 
GROUP BY A.VIP_Card, B.Goods_No, C.ColorId


    时间: 2021-08-11 15:18:15,700
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: insert into ##00a93a6621fd42a7b93da37f1d79628b
select a.VIP_Card,b.Goods_No, C.ColorId, ''
,SUM(ISNULL(C.[S1], 0)) as Quantity 
,SUM((ISNULL(C.[S1], 0))*b.DiscountPrice) as DiscountAmount 
from [CheckL] a
inner join CheckLGoods b on a.CheckID=b.CheckID
inner join CheckLDetail c on c.CheckGoodsID=b.CheckGoodsID
where a.Posted=1
and Exists(select 1 from ##a38edbc9374647258f50b04d818d4e7c where VIP=a.VIP_Card) 
and a.CheckDate>='2021/6/23' 
and a.CheckDate<='2021/7/23' 
group by a.VIP_Card,b.Goods_No, C.ColorId


    时间: 2021-08-11 15:18:15,744
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.Color = CASE WHEN RTRIM(LTRIM(ISNULL(DGC.Color,''))) = '' THEN DC.Color ELSE DGC.Color END
FROM [##00a93a6621fd42a7b93da37f1d79628b] A
LEFT JOIN DictGoodsColor DGC ON DGC.Goods_No=A.Goods_No AND DGC.ColorID=A.ColorID
LEFT JOIN DictColor DC ON DC.ColorID=A.ColorId


    时间: 2021-08-11 15:18:15,750
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card,Goods_No,Color
,SUM(Quantity) as Quantity,SUM(DiscountAmount) as DiscountAmount
into ##e36c49a7ed7448d5a10e27cd77ac6b3f
from ##00a93a6621fd42a7b93da37f1d79628b
group by VIP_Card,Goods_No,Color


    时间: 2021-08-11 15:18:15,756
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: p_DropTable ##00a93a6621fd42a7b93da37f1d79628b

    时间: 2021-08-11 15:18:15,757
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card
,SUM(Quantity) as Quantity,SUM(DiscountAmount) as DiscountAmount
into ##2d4c8924925a4f22bee438a7b882b407
from ##e36c49a7ed7448d5a10e27cd77ac6b3f
group by VIP_Card


    时间: 2021-08-11 15:18:15,760
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber , V.VIP AS [Vip卡号], V.Name AS [Vip姓名], T1.Color AS [颜色说明], SUM(ISNULL(T1.Quantity,0)) AS [数量], CAST(SUM(T1.DiscountAmount) AS NUMERIC(30,2)) AS [生意额], CASE WHEN ISNULL(SUM(T1.Quantity),0)=0 THEN NULL ELSE CAST(SUM(T1.DiscountAmount)/SUM(T1.Quantity) AS Numeric(30,2)) END AS [平均价], CASE WHEN ISNULL(MAX(T2.DiscountAmount),0)=0 THEN NULL ELSE CAST(SUM(T1.DiscountAmount)/MAX(T2.DiscountAmount) AS Numeric(30,2)) END AS [占比] 
   INTO tempdb.dbo.[bf5c1f22-641e-4527-ba12-4e0aa076f299] 
   FROM ##a38edbc9374647258f50b04d818d4e7c V 
       INNER JOIN ##e36c49a7ed7448d5a10e27cd77ac6b3f T1 ON T1.VIP_Card=V.VIP 
       LEFT JOIN ##2d4c8924925a4f22bee438a7b882b407 T2 ON T2.VIP_Card=V.VIP 
         LEFT JOIN Goods G ON G.Goods_No=T1.Goods_No
         LEFT JOIN CUSTOMER CV1 ON V.Customer_id=CV1.CUSTOMER_ID
GROUP BY  V.VIP, V.Name, T1.Color
ORDER BY  V.VIP, V.Name, T1.Color


    时间: 2021-08-11 15:18:32,936
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.* 
 INTO ##ea653fabe88b431790e3329aa7bb89af
 FROM CustomerVIP A
 WHERE 1=1 
 AND EXISTS(SELECT 1 FROM ##fc7faaafd9464c15913e6dcdf39226e6 B WHERE B.[VIP]=A.VIP) 
AND A.[ExpireDate]>GETDATE()


    时间: 2021-08-11 15:18:32,962
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.VIP_Card, B.Goods_No, C.ColorId, CAST('' AS VARCHAR(20)) AS Color
,SUM(ISNULL(C.[S1], 0)) AS Quantity 
,SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS DiscountAmount 
INTO ##e51d9732a8234b6f80d04d7119dd183b
FROM [Check] A
INNER JOIN CheckGoods B ON A.CheckID=B.CheckID
INNER JOIN CheckDetail C ON C.CheckGoodsID=B.CheckGoodsID
WHERE A.Posted=1
AND EXISTS(SELECT 1 FROM ##ea653fabe88b431790e3329aa7bb89af WHERE VIP=A.VIP_Card) 
AND A.CheckDate>='2020/12/1' 
AND A.CheckDate<='2021/8/11' 
GROUP BY A.VIP_Card, B.Goods_No, C.ColorId


    时间: 2021-08-11 15:18:33,161
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: insert into ##e51d9732a8234b6f80d04d7119dd183b
select a.VIP_Card,b.Goods_No, C.ColorId, ''
,SUM(ISNULL(C.[S1], 0)) as Quantity 
,SUM((ISNULL(C.[S1], 0))*b.DiscountPrice) as DiscountAmount 
from [CheckL] a
inner join CheckLGoods b on a.CheckID=b.CheckID
inner join CheckLDetail c on c.CheckGoodsID=b.CheckGoodsID
where a.Posted=1
and Exists(select 1 from ##ea653fabe88b431790e3329aa7bb89af where VIP=a.VIP_Card) 
and a.CheckDate>='2020/12/1' 
and a.CheckDate<='2021/8/11' 
group by a.VIP_Card,b.Goods_No, C.ColorId


    时间: 2021-08-11 15:18:33,193
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.Color = CASE WHEN RTRIM(LTRIM(ISNULL(DGC.Color,''))) = '' THEN DC.Color ELSE DGC.Color END
FROM [##e51d9732a8234b6f80d04d7119dd183b] A
LEFT JOIN DictGoodsColor DGC ON DGC.Goods_No=A.Goods_No AND DGC.ColorID=A.ColorID
LEFT JOIN DictColor DC ON DC.ColorID=A.ColorId


    时间: 2021-08-11 15:18:33,211
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card,Goods_No,Color
,SUM(Quantity) as Quantity,SUM(DiscountAmount) as DiscountAmount
into ##5cd68be323da4aee90f07a7d7b9ac7d0
from ##e51d9732a8234b6f80d04d7119dd183b
group by VIP_Card,Goods_No,Color


    时间: 2021-08-11 15:18:33,220
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: p_DropTable ##e51d9732a8234b6f80d04d7119dd183b

    时间: 2021-08-11 15:18:33,222
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card
,SUM(Quantity) as Quantity,SUM(DiscountAmount) as DiscountAmount
into ##de09548b3a9e4665895f630cfbc3aaa7
from ##5cd68be323da4aee90f07a7d7b9ac7d0
group by VIP_Card


    时间: 2021-08-11 15:18:33,228
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber , V.VIP AS [Vip卡号], V.Name AS [Vip姓名], T1.Color AS [颜色说明], SUM(ISNULL(T1.Quantity,0)) AS [数量], CAST(SUM(T1.DiscountAmount) AS NUMERIC(30,2)) AS [生意额], CASE WHEN ISNULL(SUM(T1.Quantity),0)=0 THEN NULL ELSE CAST(SUM(T1.DiscountAmount)/SUM(T1.Quantity) AS Numeric(30,2)) END AS [平均价], CASE WHEN ISNULL(MAX(T2.DiscountAmount),0)=0 THEN NULL ELSE CAST(SUM(T1.DiscountAmount)/MAX(T2.DiscountAmount) AS Numeric(30,2)) END AS [占比] 
   INTO tempdb.dbo.[bf5c1f22-641e-4527-ba12-4e0aa076f299] 
   FROM ##ea653fabe88b431790e3329aa7bb89af V 
       INNER JOIN ##5cd68be323da4aee90f07a7d7b9ac7d0 T1 ON T1.VIP_Card=V.VIP 
       LEFT JOIN ##de09548b3a9e4665895f630cfbc3aaa7 T2 ON T2.VIP_Card=V.VIP 
         LEFT JOIN Goods G ON G.Goods_No=T1.Goods_No
         LEFT JOIN CUSTOMER CV1 ON V.Customer_id=CV1.CUSTOMER_ID
GROUP BY  V.VIP, V.Name, T1.Color
ORDER BY  V.VIP, V.Name, T1.Color


    时间: 2021-08-11 18:43:40,963
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[20753543-3e88-4c4a-b2f1-ef1e769b9849]
FROM [##938b3083e7714815bf24d780bac21b81]
ORDER BY Goods_no