returing n to m rows from a query

[elmo29]

This may be a silly question but is there any way I can control which records I can return

i.e. I need to be able to return the first n rows and then n+1 to 2n, 2n+1 to 3n etc

is there any nice trick to return the groups in this sort of format or do I have to scroll though each record using a counter???

Thanks in advance

 

[Cagliostro]

select top n_records * from ... John Fill

ivfmd@mail.md

 

[tlbroadbent]

Are you asking about selecting n records at a time from SQL Server or paging through n records at a time on a web page or in a program? Terry

http://members.home.net/tlbroadbent/index.htm

 

[ragsjack]

ofcourse PAGING.

 

[tlbroadbent]

If you want to page through a record set, you can do so easily in ADO using the PageSize, PageCount and AbsolutePage properties. Don't try to page by selecting sets of records from SQL Server.

Below are some links to helpful articles.

http://www.activeserverpages.com/learn/dbtablepaged.asp

http://db101.terrashare.com/ado/paging.html

http://db101.terrashare.com/ado/db101-5.html

http://support.microsoft.com/support/kb/articles/Q202/1/25.ASP

Terry

http://members.home.net/tlbroadbent/index.htm