tag:blogger.com,1999:blog-2496415891665263000.post1047228171833880293..comments2023-10-12T13:08:57.828+02:00Comments on For the Love of Software: Paging in MS SQL Server: Pain ends hereHesham A. Aminhttp://www.blogger.com/profile/00063404912692423973noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-2496415891665263000.post-67876941866292272052008-09-05T05:16:00.000+02:002008-09-05T05:16:00.000+02:00Try this http://developmentzone.blogspot.com/2008/...Try this <A HREF="http://developmentzone.blogspot.com/2008/09/paging-from-sql-server-table-records.html" REL="nofollow">http://developmentzone.blogspot.com/2008/09/paging-from-sql-server-table-records.html</A>Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-2496415891665263000.post-53917530799322101242008-07-14T08:30:00.000+02:002008-07-14T08:30:00.000+02:00You can select count(*) in the CTE. But I'm not su...You can select count(*) in the CTE. But I'm not sure about the impact on performance.<BR/>Some applications don't allow users to navigate directly to a specific page number, it forces them to go page by page and avoids this issue.Hesham A. Aminhttps://www.blogger.com/profile/00063404912692423973noreply@blogger.comtag:blogger.com,1999:blog-2496415891665263000.post-83685191054828230562008-07-13T20:10:00.000+02:002008-07-13T20:10:00.000+02:00It is easy to get a specified range of record by "...It is easy to get a specified range of record by "between x and y". But how can I determine the max no of rownum ? If I put a number which is out of the range of records, no records will be show. Of course, you can get the recordcount by another query in advance. But is there any other way to do it?Anonymousnoreply@blogger.com