Загрузка данных


USE [myNewVasya];
GO

INSERT INTO dbo.sb_polina (kodReport)
SELECT r.kod
FROM dbo.sb_reports AS r
WHERE r.kodOrg = 0
  AND r.kodProject = 8
  AND r.tipReport = N'pers'
  AND r.srvsDT >= '20261014'
  AND r.srvsDT <  '20261020'
  AND NOT EXISTS
  (
      SELECT 1
      FROM dbo.sb_polina AS p WITH (UPDLOCK, HOLDLOCK)
      WHERE p.kodReport = r.kod
  );

SELECT @@ROWCOUNT AS insertedIntoPolina;
GO