本地服务2，报表，未加nolock,造成堵塞。

详见附件。

--DECLARE @CustomerID INT = 1
--DECLARE SELECT CONVERT(INT,item) FROM dbo.CharSplitForIn(@OrderSourceID,',') NVARCHAR(4000) = 21231
--DECLARE @Start_FirstTime DATETIME = '2021-012-01'
--DECLARE @End_FirstTime DATETIME = '2023-03-01'
--DECLARE @Start_WaitTime DATETIME = '2022-01-01'
--DECLARE @End_WaitTime DATETIME = '2023-03-01'
--DECLARE SELECT CONVERT(INT,item) FROM dbo.CharSplitForIn(@WaitToFbaType,',') DATETIME = 1

IF OBJECT_ID(N'tempdb..#SearchBaseID',N'U') IS NOT NULL
BEGIN
  DROP TABLE #SearchBaseID
END
SELECT base.ID,base.CustomerID,base.OrderSourceSKUID,base.ASINorItemID,base.OrderSourceSKU,base.SKU
INTO #SearchBaseID
FROM RB_Amazon_Product_Base base(NOLOCK) LEFT JOIN RB_Amazon_Product_Base_Local lc(NOLOCK) ON base.ID=lc.ProductBaseID
WHERE base.CustomerID=@CustomerID
AND  base.OrderSourceID IN(SELECT CONVERT(INT,item) FROM dbo.CharSplitForIn(@OrderSourceID,','))
AND  base.OrderSourceSkuOrderTime>=@Start_FirstTime
AND  base.OrderSourceSkuOrderTime<@End_FirstTime
AND  base.WaitToFbaType IN(SELECT CONVERT(INT,item) FROM dbo.CharSplitForIn(@WaitToFbaType,','))
AND base.IsDelete=0
AND base.OrderSourceSKUID>0
AND base.IsFBA=0
AND  1=1
AND  1=1

IF OBJECT_ID(N'tempdb..#ListingAsinNumber',N'U') IS NOT NULL
BEGIN
  DROP TABLE #ListingAsinNumber
END
SELECT base.ASINorItemID,COUNT(base.ID) AS Number
INTO #ListingAsinNumber
FROM RB_Amazon_Product_Base base INNER JOIN #SearchBaseID parent
ON base.CustomerID=parent.CustomerID AND base.ASINorItemID=parent.ASINorItemID
WHERE base.ID<>parent.ID AND base.IsFBA=1 AND parent.ASINorItemID<>''
GROUP BY base.ASINorItemID