June 20, 2005 at 8:40 am
I would like to implement paging functionality from the sql. I have found many articles in the net which has accomplished this task but all the approaches have either
1) Used a table datatype with an identity column to store all records and then retrieve the required ones. The identity column indicates the row position of the records which will help out in fetching the records from the correct page. This solution provides me with the solution but table operation for a huge record base is a performance intensive one.
Is there a better way to implement paging.
2) Using rowcount - But works only in Identity fields
Need a good solution which
1) Will be able to return records in which ever order the user chooses. Eg if the user selects to sort on the name by desc and needs the records in Page 10 then the procedure should be able to first sort on the name and then fetch the records in the 10th page
June 21, 2005 at 2:01 am
See if this helps: http://www.aspfaq.com/show.asp?id=2120
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply