UPDATE a
SET a.ProductSku = b.ProductSku
FROM RB_Shopee_Listing a (nolock)
INNER JOIN RB_Shopee_Listing b (nolock)
ON a.CustomerId = b.CustomerID
AND a.ModelId = b.ShopeeId
WHERE a.CustomerId = 1
AND a.ListingVersion = 2
AND ( a.ProductSku = ''
OR a.ProductSku IS NULL )
AND ( b.ProductSku != ''
AND b.ProductSku IS NOT NULL )
AND b.ListingVersion != 2
同一时间重复调用,查一下具体原因。