paging.sql

USE [db]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[load_pids]
@Skip AS INT,
@Take AS int
AS
BEGIN

SELECT * FROM	(
				SELECT COUNT(mt.pid) OVER() [TotalRows], ROW_NUMBER() OVER(ORDER BY mt.prid) AS [RowNum], mt.pid, mt.repo_name
				from db.dbo.mytable mt
			) AS [InsideQuery]

WHERE [RowNum] BETWEEN	(@Skip * @Take) + 1 AND (@Skip + 1) * @Take 

END