Paging in the Set values | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Paging in the Set values

Hi All, I have got huge number of rows (1,00,000) in the view. I want to get top 15 values when a click event done on the page number. For every next page click event get next 15 records from the database. Can you plz provide any solution Thank You With Regards
Aruna Mathew
Paging Records Using SQL Server 2005 Database – ROW_NUMBER Function
http://davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx http://www.sqlmag.com/articles/index.cfm?articleid=43922&
MohammedU.
Moderator
SQL-Server-Performance.com
]]>