Update ezresével

Update1000.sql

DECLARE @MSG NVARCHAR(MAX),
  @LASTCCOUNT INT,
  @PRCCOUNT INT
    
SET @PRCCOUNT =
(SELECT COUNT(1) 
FROM [Prisoners]
WHERE [WasDentalReceiving] = 1 AND [EUAdatokFeladva] = 0)
   
SET @LASTCCOUNT = -1

WHILE @PRCCOUNT <> @LASTCCOUNT
BEGIN
  SET @LASTCCOUNT = @PRCCOUNT

  UPDATE [Prisoners]
  SET [WasDentalReceiving] = 0
  WHERE [ID] IN (
    SELECT TOP 1000 [ID] 
    FROM [Prisoners] 
    WHERE [WasDentalReceiving] = 1 AND [EUAdatokFeladva] = 0 
    ORDER BY [ID])

  SET	@PRCCOUNT =
  (SELECT COUNT(1) 
  FROM [Prisoners]
  WHERE [WasDentalReceiving] = 1 AND [EUAdatokFeladva] = 0)

  SET @MSG = '1. Last prisonerid set count yet: ' + CONVERT(NVARCHAR(20), @PRCCOUNT) + ' time: ' + CONVERT(NVARCHAR(64), GETDATE(), 120)

  RAISERROR(@MSG, 0, 1) WITH NOWAIT
END