January 13, 2005 at 7:23 am
Good day every one,
Does anyone know of a way of retrieving certain amount of records from a table e.g. For batches of 50 I wish to receive the first 50 records(records 1...50) ... Execute another sql statement that will retrieved the next 50 records(records 51...100) ...etc.
Please Help
Regard
Sheldon
January 13, 2005 at 7:32 am
welcome to the forum.
Maybe this can get you on track ...
http://www.sqlservercentral.com/columnists/jwiner/moreonreturningasubsetofarecordset_1.asp
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
January 14, 2005 at 12:29 am
Thank you very much! It was just what I was looking 4 and more!
Regards
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply