CREATE PROCEDURE dbo.test_page
AS
    BEGIN

        declare @id numeric,
                @count int,
                @count_page int

        declare tcursor cursor for select p.id from pps_payments p where p.id <  200  

        select @count =  0 
        select @count_page =  0 

        open tcursor

        fetch tcursor into @id 

        while @@sqlstatus =  0 
        begin

            select @count = @count +  1 

            if (@count >=  50  and @count <=  100 )
                begin
                    select @count_page = @count_page +  1 

                    if (@count_page =  1 )
                        select * into #t_t from pps_payments p where p.id = @id
                    else
                        insert into #t_t select * from pps_payments p where p.id = @id
                end

            if (@count >  100 ) 
                break
       
        end
        close tcursor
        deallocate cursor tcursor


        select * from #t_t

    END