[步骤]

(@CustomerID int,@BeforeDays int,@tbSKUList [Tb_StringIds] READONLY)                


SELECT pdsl.AddTime AS OrderTime,
       a.ActualBuyNum,
       de.SingleNum,
       a.ActualProductPrice,
       a.UnitShipFee,
       pdsl.Single_NO,
       a.SKU
FROM   dbo.RB_Procurement_Detail_BuyList_Detail AS a (nolock)
       LEFT JOIN dbo.RB_Procurement_Detail_BuyList AS b (nolock)
         ON a.ListNo = b.ListNo
       LEFT JOIN RB_Procurement_Detail AS de (nolock)
         ON a.P_Code = de.P_Code
            AND a.SKU = de.SKU
       LEFT JOIN RB_Procurement_Detail_SingleList pdsl WITH(nolock)
         ON pdsl.CustomerID = b.CustomerID
            AND pdsl.P_Code = b.P_Code
            AND pdsl.Single_NO = b.Single_NO
WHERE  a.CustomerId = @CustomerID
       AND a.ActualProductPrice > 0
       AND pdsl.AddTime > Dateadd(DAY, @BeforeDays, Getdate())
       AND a.SKU IN (SELECT Id
                     FROM   @tbSKUList) 

[结果]

[期望]

排查问题 优化 SQL