时间: 2021-03-20 17:46:20,772
  线程ID: 59
日志级别: 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.[5a551f02-bc0c-4546-8b51-6f4707894d35]
FROM [##efc81a530d1441ffa9344df259070297]
ORDER BY Goods_no


    时间: 2021-03-20 17:47:28,707
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量
    , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量
    , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量
INTO [##2610422cd7e349b2bcead2cf7b88a25c]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-20 17:47:28,993
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##2610422cd7e349b2bcead2cf7b88a25c] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##35990a92802a41e786bda3f416e30de8] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID