quote:

---

Originally posted by amirs

hi
im my table their are 10,00000 record.
it is posible to select first 10 , in next to start 11 to 20 ,in prev select 10 records and last 10 records in table to select query
means is posible to pagination of first,next,prev and last record and display the 10 records.
i am using sql server2005

---

quote:

---

Originally posted by amirs

hi
im my table their are 10,00000 record.
it is posible to select first 10 , in next to start 11 to 20 ,in prev select 10 records and last 10 records in table to select query
means is posible to pagination of first,next,prev and last record and display the 10 records.
i am using sql server2005

---

CREATE PROCEDURE GetPagedResults
@PageSize int=10,
@PageNo int=1
AS
SELECT columns
FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY PK) AS Row_No,*
FROm YourTable
)t
WHERE t.RowNo BETWEEN (@PageNo-1)*@PageSize+1 AND @PageNo*@PageSize
GO


then call it like 
GetPagedResults 10,1 --gets first page records
GetPagedResults 10,5 --gets 5th page records

for getting last page just use
DECLARE  @LastPage int
SELECT @LastPage= CIELING(COUNT(1)/@PageSize) FROM YourTable