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.
Author |
Topic |
adbasanta
Posting Yak Master
120 Posts |
Posted - 2013-01-01 : 19:35:51
|
Good day!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 recordsMove Previous - Will move to previous 500 recordsMove Next - Will move to next 500 recordsMove last - Will move to last 500 recordsHow to pass a query like this when one of the buttons are clicked?Thank you!-------------------------------------------------------------------------------------------------------Learning MS SQL Server 2008 |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
adbasanta
Posting Yak Master
120 Posts |
Posted - 2013-01-03 : 00:25:56
|
Thank you visakh16!The link is very helpful.Ill post the query soon and post here back the result!-------------------------------------------------------------------------------------------------------Learning MS SQL Server 2008 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-03 : 01:13:25
|
welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|