Введите краткое описание своих изменений
(Обязательно)
Minor changes are by default collapsed in the page history.
No changes
The page does not exist yet.
Failed to load changes
Версия от на
Leave Collaboration
Are you sure you want to leave the realtime collaboration and continue editing alone? The changes you save while editing alone will lead to merge conflicts with the changes auto-saved by the realtime editing session.
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
Рассмотреть вариант: передать xml объект и выполнить join
https://stackoverflow.com/questions/19905092/how-to-join-xml-nodes-to-table-column