[步骤]

exec sp_executesql N'SELECT DISTINCT iib.OperateType,alias.*                            FROM  RB_Inventory_DetailLog alias(NOLOCK)                         LEFT JOIN dbo.RB_Inventory_InOutBallance iib ON alias.CustomerID = iib.CustomerID                         AND alias.OriginBillNumber = iib.BallanceNumber                         AND alias.SKU = iib.SKU                         AND alias.RealtionId = iib.ID                                LEFT JOIN dbo.RB_WareHouse wh WITH (NOLOCK) ON alias.WareHouseID=wh.ID AND alias.CustomerID=wh.CustomerID                                LEFT JOIN RB_Report_FULFILLMENT_REMOVAL_ORDER_DETAIL_Increment(NOLOCK)                             ON Disposition = ''Unsellable'' and [order-type]=''Liquidations'' and RB_Report_FULFILLMENT_REMOVAL_ORDER_DETAIL_Increment.sku like ''amzn.gr%''                                 AND CONVERT(VARCHAR(50), RB_Report_FULFILLMENT_REMOVAL_ORDER_DETAIL_Increment.ID) = iib.AssociatedBallanceNumber                            WHERE alias.CustomerID = 1 AND alias.BillType IN(1,3) AND alias.AddTime>@StartTime                                 AND RB_Report_FULFILLMENT_REMOVAL_ORDER_DETAIL_Increment.ID IS NULL                             AND wh.WareHouseType NOT IN(1)                              AND (iib.OperateType IS NULL OR iib.OperateType NOT IN(50,51,52,53))                             ORDER BY alias.AddTime ASC ',N'@StartTime datetime',@StartTime='2026-05-07 03:23:26.240'

[结果]

[期望]

提升性能 减少资源消耗