Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Govdark
Starting Member
4 Posts |
 Posted - 2005-07-11 : 13:28:47
|
| HiI have problem with SQL in fetching minimal records from a resultset. A table consists of 500000 records, by refering with other tables i am executing a query which will fetch 50000 records from 500000 records, I want this 50000 records in page navigation setup. For example there may be buttons like Next 5, Next 10, Next 15, Next 20, Last, Previous 5, Previous 10, previous 15, Previous 20 and First, here the records has to popuplate in 5 or 10 or 15 or 20 as per the selection. Is there any special function or technique to do this is SQL server.Thanks" Tough times does not last long, but tough people do. " |
|
|
Kristen
Test
22859 Posts |
|
|
Govdark
Starting Member
4 Posts |
Posted - 2005-07-11 : 14:09:30
|
| Thanks for your immediate reply.It seems sounds good. But I need to do deep observing and get back to you." Tough times does not last long, but tough people do. " |
 |
|
|
|
|
|
Fetching number of records like "mySQL Limit"