SQL：
(@Ids nvarchar(max) ,@customerId int)DROP TABLE IF EXISTS #tbAmazonUploadResultV2IDs;DROP TABLE IF EXISTS #tempRes1;CREATE TABLE #tempRes1
(
item VARCHAR(20)
);INSERT INTO #tempRes1 EXEC proc_string_split @ids,',';SELECT CONVERT(INT, item) AS Id INTO #tbAmazonUploadResultV2IDs FROM #tempRes1;CREATE INDEX idx_temp_id ON #tbAmazonUploadResultV2IDs(id);SELECT v2.[ID],
[CustomerID],
[OrderSourceID],
[FeedSubmissionId],
[TemplateID],
[Status],
[Msg],
[AddTime],
[AddUserID],
[AddUserName],
[UpdateTime],
[UpdateUserID],
[UpdateUserName],
[RecommendedBrowseNodeName],
[TranslateStatus],
[RecommendedBrowseNode],
[BrowsePathByID],
[Rank],
[PlanId],
[UploadType]
FROM [RB_AmazonUploadResult_V2] (nolock) v2
INNER JOIN #tbAmazonUploadResultV2IDs t
ON v2.ID = t.ID
WHERE v2.CustomerID = @customerId;
DROP TABLE IF EXISTS #tbAmazonUploadResultV2IDs;DROP TABLE IF EXISTS #tempRes1;
大量临时表操作IO开销高，并发导致ERP库卡顿，主库读库间数据同步延迟
