Here is another simple SP for Paging that works even in SQL-2k.

------------------------------------------

CREATE Procedure usp_GetPagedOrders

@PageIndex integer,

@PageSize integer

---*** HOW TO USE USE *** ----

--- EXEC usp_GetPagedOrders 10, 25

--- Parameters Defination:

--- @PageIndex --> Page Number which you want to show

--- @PageSize --> List of Records in each Page

---*** HOW TO USE USE *** ----

AS

Declare @StartID integer,

@EndID integer

Declare @Temp table (

ID integer IDENTITY(1, 1) NOT NULL,

OrderID integer NOT NULL,

CustomerID nchar(5) NULL,

OrderDate datetime NULL,

Freight money NULL)

SET NOCOUNT ON

Insert @Temp (

OrderID,

CustomerID,

OrderDate,

Freight)

Select OrderID,

CustomerID,

OrderDate,

Freight

From Orders

Set @StartID = @PageIndex * @PageSize + 1

Set @EndID = (@PageIndex + 1) * @PageSize

Select OrderID,

CustomerID,

OrderDate,

Freight

From @Temp

Where ID Between @StartID And @EndID

GO

------------------------------------------