时间: 2021-03-08 16:05:02,941
  线程ID: 110
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], A.Long AS [内长], SUM(A.Quantity) AS [数量], GS.UnitPrice AS [吊牌价]
INTO tempdb.dbo.[11084507-e478-41c9-864a-94c24425a486]
FROM ##f6cfeacce0bf45e3931e47659400b229 A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, A.Long, GS.UnitPrice

ORDER BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, A.Long, GS.UnitPrice


    时间: 2021-03-08 16:05:37,607
  线程ID: 113
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], A.Long AS [内长], SUM(A.Quantity) AS [数量], GS.UnitPrice AS [吊牌价]
INTO tempdb.dbo.[11084507-e478-41c9-864a-94c24425a486]
FROM ##755aebb8e5b844ed8b5edc2de6875c49 A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, A.Long, GS.UnitPrice

ORDER BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, A.Long, GS.UnitPrice


    时间: 2021-03-08 16:07:37,116
  线程ID: 113
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], A.Long AS [内长], SUM(A.Quantity) AS [数量], GS.UnitPrice AS [吊牌价]
INTO tempdb.dbo.[11084507-e478-41c9-864a-94c24425a486]
FROM ##9e6d9a1ce6364d48b4a8563364582f9f A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, A.Long, GS.UnitPrice

ORDER BY  CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, A.Long, GS.UnitPrice