I am having a little slow performance loading 10,000 items in one instance. I have decided to load the items @ 500 per records with the following buttons on my Front End apps:
Move First - Will move to first 500 records Move Previous - Will move to previous 500 records Move Next - Will move to next 500 records Move last - Will move to last 500 records
How to pass a query like this when one of the buttons are clicked?
Thank you!
------------------------------------------------------------------------------------------------------- Learning MS SQL Server 2008