Best Paging Procedure | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Best Paging Procedure

I have very large table .I have to show the information from table to user in pages.
after filtering the data through where clause.suppose based on input condition 200
records are fetched and only records from 61 to 80 ,
no of pages and the no of records are to be shown .
Suggest the best procedure for it.

Check out the discussion here:
Frank Kalis
Microsoft SQL Server MVP
Heute schon gebloggt?

Refer that to know many aprroaches Madhivanan Failing to plan is Planning to fail