What I'm trying to archieve is something like this untested (and incorrect) code (just wrote it down)

DECLARE @counter INT = 0

DECLARE @RwCnt INT = @@rowcount

WHILE @counter <= @RwCnt

BEGIN

INSERT INTO SELECT TOP (1000) FROM .........

SET @counter = @counter + 1000

END

Only problem is I don't know how to specify the record batch in the SELECT statement. How to link the select to the @counter.

I'm trying to make loops of 1000 records.