Fetching 1000 rows at a time
I need a sql statment that will fetch 1000 rows at a time
for example i have got a table called customer which consist of 7500 rows
in my first fetch i need
1 fetch -- 0 -1000 rows
2 fetch -- 1001 -2000 rows
1 fetch -- 2001 -3000 rows
1 fetch -- 3001 -4000 rows
I am really dying to have a sql statement to fetch like this manner...
i know using TOP keyword to fetch first 1000 but how can i fetch the next
Thanks in advance
Re: Fetching 1000 rows at a time
Look for serverside paging in google, there are tons of hits out there,
HTH, jens Suessmeyer.