declare @maxi int
declare @i int
declare @j int
declare @identity_storage numeric(20,0)
select @maxi = 1000
select @i = 1
select @j = 1


while @i<@maxi
begin
	while @j<=10
	begin
		select @j = @j+1
		insert into TAB1(ID, NAME) values (@i, 'some_data')
	end
	select @i = @i+1
	select @j = 1
end
go