Get particular row using SPROC 1

[whatsthehampton]

HI,

I have a grid with paging - when the grid is paged I want to get the top row for each page - so for example if the paging is set at 10 records I need to get the 11th record, 21st record and so on.

How can I do this with a stored procedure please?

Cheers,

J

http://www.iews.co.uk/

 

[markros]

Take a look at

http://www.code-magazine.com/article.aspx?quickid=0703041&page=2

 

[whatsthehampton]

Many thanks markros,

That led me to this Sproc which will work in SQL Server 2005 and did the trick nicely.

SELECT * FROM
(SELECT Row_Number() OVER (ORDER BY jobid desc) as rowid,
jobid, jobdesc, jobtitle
FROM tbl_jobs )
as a
where rowid = @rowid

Now, whatever the paging size is I can calculate and get the specific row I need. i.e.

@rowid = (PageSize * PageNumber) + 1

Cheers,

J

http://www.iews.co.uk/

 

[markros]

You're welcome, glad to help.