时间: 2020-11-24 10:58:45,188 线程ID: 58 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称] ,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式] ,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额] ,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣] ,[Group] [组], Company_ID [公司编号], SaleMan [业务员] ,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别] INTO tempdb.dbo.[cd82f07c-47ad-44b2-8e54-6bbe60646764] FROM Customer A INNER JOIN [##f3631e5f53f34002b397431176882ffe] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID 时间: 2020-11-24 14:25:36,853 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 B.Goods_No, C.ColorID, C.Long , B.Quantity AS 自营#数量, B.DiscountPrice*B.Quantity AS 自营#生意额 , B.Quantity AS 加盟#数量, B.DiscountPrice*B.Quantity AS 加盟#生意额 , B.Quantity AS 合计#数量, B.DiscountPrice*B.Quantity AS 合计#生意额 INTO ##043e7672ca0b4aa6807799785addd682 FROM CheckGoods b,CheckDetail c 时间: 2020-11-24 14:25:36,871 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##043e7672ca0b4aa6807799785addd682 (Goods_No, ColorID, Long, 自营#数量, 自营#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [Check] A INNER JOIN CheckGoods B ON A.CheckID=B.CheckID INNER JOIN CheckDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##db51093d82104aecaa98efd07cf823bd WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##14ff309187754620b72c547dde8183eb WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2020-10-24' AND A.CheckDate <= '2020-11-24' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2020-11-24 14:25:36,922 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##043e7672ca0b4aa6807799785addd682 (Goods_No, ColorID, Long, 加盟#数量, 加盟#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [CheckL] A INNER JOIN CheckLGoods B ON A.CheckID=B.CheckID INNER JOIN CheckLDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##db51093d82104aecaa98efd07cf823bd WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##14ff309187754620b72c547dde8183eb WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2020-10-24' AND A.CheckDate <= '2020-11-24' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2020-11-24 14:25:36,973 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称] , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额 INTO tempdb.dbo.[dad966fd-e7d7-45f9-b818-68515b79a2e2] FROM ##043e7672ca0b4aa6807799785addd682 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No GROUP BY A.Goods_No, GS.Goods_Name ORDER BY A.Goods_No, GS.Goods_Name 时间: 2020-11-24 14:39:53,987 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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(NULL AS NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], CAST(NULL AS INT) AS [渠道采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道采购退货#金额] , CAST(C.[S1] AS INT) AS [渠道收货#S1], CAST(NULL AS INT) AS [渠道收货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], CAST(NULL AS INT) AS [渠道退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道退货#金额] , CAST(C.[S1] AS INT) AS [渠道调出#S1], CAST(NULL AS INT) AS [渠道调出#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], CAST(NULL AS INT) AS [渠道调入#数量], CAST(NULL AS NUMERIC(15, 2)) 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 [渠道销售#正常销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) 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 [在途库存#数量] , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS [库存合计#数量] INTO [##d8c4e0f653574affa2754a4e9ab2d9c3] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2020-11-24 14:39:54,137 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d8c4e0f653574affa2754a4e9ab2d9c3] (Customer_ID, Goods_No, ColorID, Long, [期初库存#S1], [期初库存#数量]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##cce675b4e7134500a477ecbe03cd0d65] 时间: 2020-11-24 14:39:54,187 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d8c4e0f653574affa2754a4e9ab2d9c3] (Customer_ID, Goods_No, ColorID, Long, [渠道采购退货#S1], 渠道采购退货#数量, 渠道采购退货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##336a1d5f978a4012950d2fe1646e28ef] 时间: 2020-11-24 14:39:54,248 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d8c4e0f653574affa2754a4e9ab2d9c3] (Customer_ID, Goods_No, ColorID, Long, [渠道收货#S1], 渠道收货#数量, 渠道收货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##6257765235fd40399471665e3c57758c] 时间: 2020-11-24 14:39:54,291 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d8c4e0f653574affa2754a4e9ab2d9c3] (Customer_ID, Goods_No, ColorID, Long, [渠道退货#S1], 渠道退货#数量, 渠道退货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##c9cb2b361893437ebeed67ad8140c30c] 时间: 2020-11-24 14:39:54,338 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d8c4e0f653574affa2754a4e9ab2d9c3] (Customer_ID, Goods_No, ColorID, Long, [渠道调出#S1], 渠道调出#数量, 渠道调出#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##9207ec9b9ea144fb8ed70d2f66b09621] 时间: 2020-11-24 14:39:54,395 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d8c4e0f653574affa2754a4e9ab2d9c3] (Customer_ID, Goods_No, ColorID, Long, [渠道调入#S1], 渠道调入#数量, 渠道调入#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##1c021a9c3601491498e7090d9abc2200] 时间: 2020-11-24 14:39:54,441 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d8c4e0f653574affa2754a4e9ab2d9c3] (Customer_ID, Goods_No, ColorID, Long, [渠道损益#S1], 渠道损益#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b6c0d70fc56e419787c2e0abb27775ff] 时间: 2020-11-24 14:39:54,499 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d8c4e0f653574affa2754a4e9ab2d9c3] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##2a2175b04e7f4c2a8e42b6491fc22022] 时间: 2020-11-24 14:39:54,531 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d8c4e0f653574affa2754a4e9ab2d9c3] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##805dac353eb6455baa1ecd2548a36f44] 时间: 2020-11-24 14:39:54,559 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d8c4e0f653574affa2754a4e9ab2d9c3] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售自提#S1], [渠道销售#预售自提#数量], [渠道销售#预售自提#生意额], [渠道销售#预售自提#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##6d2f876df8de414cb074d8638b3ff815] 时间: 2020-11-24 14:39:54,587 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d8c4e0f653574affa2754a4e9ab2d9c3] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上发货#S1], [渠道销售#线上发货#数量], [渠道销售#线上发货#生意额], [渠道销售#线上发货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##8bd1cb7fc2d44351a24509024742e025] 时间: 2020-11-24 14:39:54,615 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d8c4e0f653574affa2754a4e9ab2d9c3] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上退货#S1], [渠道销售#线上退货#数量], [渠道销售#线上退货#生意额], [渠道销售#线上退货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##17be9344faa8471c9315dd532ac3ac84] 时间: 2020-11-24 14:39:54,983 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d8c4e0f653574affa2754a4e9ab2d9c3] (Customer_ID, Goods_No, ColorID, Long, [在途库存#S1], [在途库存#数量]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0c31456b978143518a238281b024d2fd] 时间: 2020-11-24 14:39:54,995 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d8c4e0f653574affa2754a4e9ab2d9c3] SET 期末库存#数量 = ISNULL(期初库存#数量,0) + ISNULL(渠道采购收货#数量,0) - ISNULL(渠道采购退货#数量,0) + ISNULL(渠道收货#数量,0) - ISNULL(渠道退货#数量,0) - ISNULL(渠道调出#数量,0) + ISNULL(渠道调入#数量,0) - ISNULL(渠道损益#数量,0) - ISNULL(渠道销售#正常销售#数量,0) - ISNULL(渠道销售#线上发货#数量,0) - ISNULL(渠道销售#线上退货#数量,0) 时间: 2020-11-24 14:39:54,997 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d8c4e0f653574affa2754a4e9ab2d9c3] SET 库存合计#数量 = ISNULL(期末库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2020-11-24 14:39:54,999 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([期初库存#数量]) AS [期初库存#数量], SUM([渠道收货#数量]) AS [渠道收货#数量], SUM([渠道收货#金额]) AS [渠道收货#金额], SUM([渠道退货#数量]) AS [渠道退货#数量], SUM([渠道退货#金额]) AS [渠道退货#金额], SUM([渠道调出#数量]) AS [渠道调出#数量], SUM([渠道调出#金额]) AS [渠道调出#金额], SUM([渠道调入#数量]) AS [渠道调入#数量], SUM([渠道调入#金额]) AS [渠道调入#金额], SUM([渠道损益#数量]) AS [渠道损益#数量], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售#数量], SUM([渠道销售#正常销售#生意额]) AS [渠道销售#正常销售#生意额], SUM([渠道销售#正常销售#结算额]) AS [渠道销售#正常销售#结算额], SUM([期末库存#数量]) AS [期末库存#数量], SUM([库存合计#数量]) AS [库存合计#数量] INTO tempdb.dbo.[a11b91df-b5bb-4b0f-b35b-2237d4d083e6] FROM [##d8c4e0f653574affa2754a4e9ab2d9c3] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER 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 A.Customer_ID, CT.Abbrev, A.Goods_No, GS.Goods_Name HAVING (ISNULL(SUM([期初库存#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购收货#S1]), 0) <> 0) OR SUM([渠道采购收货#金额]) <> 0 OR (ISNULL(SUM([渠道采购退货#S1]), 0) <> 0) OR SUM([渠道采购退货#金额]) <> 0 OR (ISNULL(SUM([渠道收货#S1]), 0) <> 0) OR SUM([渠道收货#金额]) <> 0 OR (ISNULL(SUM([渠道退货#S1]), 0) <> 0) OR SUM([渠道退货#金额]) <> 0 OR (ISNULL(SUM([渠道调出#S1]), 0) <> 0) OR SUM([渠道调出#金额]) <> 0 OR (ISNULL(SUM([渠道调入#S1]), 0) <> 0) OR SUM([渠道调入#金额]) <> 0 OR (ISNULL(SUM([渠道损益#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR SUM([渠道销售#正常销售#生意额]) <> 0 OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR SUM([渠道销售#预售直发#生意额]) <> 0 OR (ISNULL(SUM([渠道销售#预售自提#S1]), 0) <> 0) OR SUM([渠道销售#预售自提#生意额]) <> 0 OR (ISNULL(SUM([渠道销售#线上发货#S1]), 0) <> 0) OR SUM([渠道销售#线上发货#生意额]) <> 0 OR (ISNULL(SUM([渠道销售#线上退货#S1]), 0) <> 0) OR SUM([渠道销售#线上退货#生意额]) <> 0 OR (ISNULL(SUM([在途库存#S1]), 0) <> 0) ORDER BY A.Customer_ID, CT.Abbrev, A.Goods_No, GS.Goods_Name 时间: 2020-11-24 14:41:39,486 线程ID: 38 日志级别: 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.[9bb626b3-dbbd-413f-82ba-0fb686ea1943] FROM [##147276277dfa47e88ad9b0d3ed437dab] ORDER BY Goods_no 时间: 2020-11-24 14:54:43,097 线程ID: 45 日志级别: 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.[004a2567-b08b-4dc9-9013-ec43b7fde609] FROM [##9763d82f18d04d6fa65418ca4f44010c] ORDER BY Goods_no 时间: 2020-11-24 14:58:04,870 线程ID: 40 日志级别: 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.[ea367c5e-b12e-459e-b211-3832fb9972f5] FROM [##e5bd2b6213b645a6beb6e4e92a925ee0] ORDER BY Goods_no