SQL Server Performance Forum – Threads Archive
Best Paging ProcedureI 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:http://www.aspfaq.com/show.asp?id=2120 —
Microsoft SQL Server MVP
Heute schon gebloggt?http://www.insidesql.de/blogs
Refer that to know many aprroaches Madhivanan Failing to plan is Planning to fail