SQL：
(@CustomerID int,@OrderSourceID int)
declare @tabRep table
(id int primary key,ListingPrice decimal(18,2),ListingSoldNum nvarchar(100),ISFBA bit,IsOffShelf int,ASINorItemID nvarchar(50),UpdateTime datetime,KykcNum int);
insert into @tabRep
select distinct ossku.id,
report.ListingPrice,
report.ListingSoldNum,
report.ISFBA,
report.IsOffShelf,
report.ASINorItemID,
'2023-10-22 08:34:18' UpdateTime,
report.KykcNum
FROM RB_Amazon_Product_Base ossku (nolock)
INNER JOIN RB_AmazonListingOnline_SoldReportTemp report WITH(nolock)
ON ossku.Id = report.ErpKeyId
WHERE ossku.CustomerID = @CustomerID
AND ossku.OrderSourceID = @OrderSourceID;
UPDATE ossku
SET ossku.ListingPrice = report.ListingPrice,
ossku.ListingSoldNum = report.ListingSoldNum,
ossku.ISFBA = report.ISFBA,
ossku.IsOffShelf = report.IsOffShelf,
ossku.ASINorItemID = report.ASINorItemID,
ossku.UpdateTime = report.UpdateTime,
ossku.KykcNum=report.KykcNum
FROM RB_Amazon_Product_Base ossku
INNER JOIN @tabRep report on ossku.id=report.id;
大量使用临时表，高io开销，并发导致erp库卡顿
