| Maria 2003-11-30, 11:24 am |
| Check out the artcle "Server-side Paging with SQL Server"
by Andrew Rosca, here:
http://rosca.net/writing/articles/serverside_paging.asp
He goes into much more detail in the December issue of SQL
Server magazine (just out). in an article with the same
name. It starts with a TOP 10 query like yours and then
walks you through the code you need to 'page' on demand
through the remainder.
You can get a sample issue of the magazine here:
http://www.sqlmag.com/
hth
Maria
>-----Original Message-----
>I have a set of tables with almost 2,00,000 records each.
>I want to search for a particular condition using JOIN
and
>THEN retreive only 20th - 30th record; and not all.
>
>I can use TOP 10 to get 1-10th record; but that doesn't
>solve my purpose as I display the records in a Webpage
>with 10 records each page; and when the user is in the
9th
>page i got to display 90th - 100th record; and so on.
>
>
>DONT want to use cursors.
>Is there any hidden row returned by SQL 2000 which
>contains Serial Number; i.e the record position which
>helps me to achieve it.
>.
>
|