get next N records

[JohnSouth]

Hi
I'm sure this is an old perennial, so feel free to refer me to earlier answers..
How so I get SQL to return me the next/previous N records from a table that does not have a suitable unique key I can use to fix the start point?

I can get the first N with SELECT TOP, but after that it gets difficult.

JohnSouth
Pangbourne UK


John South
JS Associates
Pangbourne UK

 

[forecasting]

I haven't figured out how to use the thread identifier, but if you go to the keyword search tab and enter

"How to return a range of records " there is a good discussion and with code how to do it.

 

[tlbroadbent]

The thread that forecasting referred to is thread183-56272. To post a thread number in a message, go to the upper left corner of the thread, copy the thread number including the word "thread" and paste it in the message box as I did in this message.

For more info on paging in SQL Server, check the following links.

http://www.15seconds.com/issue/010308.htm

http://www.microsoft.com/sql/techinfo/tips/administration/resultset.asp

http://www.aspfaqs.com/webtech/062899-1.shtml

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.