Create below procedure to implement paging:
CREATE PROCEDURE dbo.proc_Paging_TempTable
(
@Page int,
@RecsPerPage int
)
AS
SET NOCOUNT ON;
DECLARE @FirstRec int, @LastRec int;
SELECT @FirstRec = (@Page - 1) * @RecsPerPage
SELECT @LastRec = (@Page * @RecsPerPage + 1)
WITH TempResult AS
(
SELECT ROW_NUMBER() OVER(ORDER BY id) AS RowNum, id, id_2, car_num, photo, doc_type
FROM Table_2
)
SELECT *
FROM TempResult
WHERE RowNum > @FirstRec
AND RowNum < @LastRec;
GO
EXEC proc_Paging_TempTable 1, 5
You need to pass page no and no of page to stored procedure. In preceding procedure it is passing page no as 1 and no of records per page is 5. If you want next result set then you need to pass 2,5