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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Divide Query into several pages

Author  Topic 

Swede
Yak Posting Veteran

74 Posts

Posted - 2002-01-09 : 09:13:26
ASP Related

Hi again guys... and maybe women... if there are any.

I have been experimenting on continuing a SELECT statement where I last ended it. Sort of like if I wanted to divide one search result into several pages... Cannot get it to work efficiently (just got it to work by doing the same query again and chosing a movenext until I end up at the same position as I marked before..)

Any help to be had in this problem too?

=====================================
Why not try and do the impossible?

Nazim
A custom title

1408 Posts

Posted - 2002-01-09 : 09:27:25
Read this Article's
http://www.sqlteam.com/item.asp?ItemID=2753
http://www.sqlteam.com/item.asp?ItemID=3078

This should help you.


----------------------------
Anything that Doesn't Kills you Makes you Stronger
Go to Top of Page

Swede
Yak Posting Veteran

74 Posts

Posted - 2002-01-09 : 09:33:46
Just what I was looking for! Many thanks!

=====================================
Why not try and do the impossible?
Go to Top of Page
   

- Advertisement -