/*Starting place*/
SELECT TOP (1)
    @NextBatchMax  = SQ1.id
FROM
(
    SELECT TOP (1000) aia.id
    FROM dbo.as_i_am AS aia
    WHERE aia.id > @LargestKeyProcessed
    ORDER BY aia.id ASC
) AS SQ1
ORDER BY SQ1.id DESC;

SELECT @NextBatchMax = aia.id
FROM dbo.as_i_am AS aia
WHERE aia.id > @LargestKeyProcessed
ORDER BY aia.id ASC
OFFSET 1000 ROWS
FETCH NEXT 1 ROW ONLY;

/*Starting place*/
SELECT @NextBatchMax = MAX(SQ1.id)
FROM
(
    SELECT TOP (1000) aia.id
    FROM dbo.as_i_am AS aia
    WHERE aia.id > @LargestKeyProcessed
    ORDER BY aia.id ASC
) AS SQ1;

DECLARE Batch CURSOR LOCAL DYNAMIC SCROLL FOR
SELECT AIA.id FROM dbo.as_i_am AS AIA ORDER BY AIA.id ASC;
OPEN Batch;
FETCH FIRST FROM Batch;
FETCH RELATIVE 1000 FROM Batch;
-- etc.