Комментарий к Поиск в таблице по списку ключей

1)
select *
from dbo.MainEntities
where I in (1000,1001,1002 ...)

2)
DROP TABLE IF EXISTS #TmpData

CREATE TABLE #TmpData
(ID INT)


INSERT INTO #TmpData
VALUES (1000), (1001), (1002), ...

...

SELECT *
FROM #TmpData td
JOIN dbo.MainEntities me on td.ID = me.I

DROP TABLE IF EXISTS #TmpData

3)
Declare @idList xml = '
<ArrayOfInt>
  <int>1000</int>
  <int>1001</int>  
  ...
</ArrayOfInt>'

Select
me.*
From @idList.nodes('/ArrayOfInt/int') AS idList(id)
   JOIN dbo.MainEntities me on idList.id.value('.', 'int') = me.I