SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Movefisrt, MovePrevious, MoveNext, Movelast..?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

adbasanta
Posting Yak Master

120 Posts

Posted - 01/01/2013 :  19:35:51  Show Profile  Reply with Quote
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 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

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 01/01/2013 :  23:46:17  Show Profile  Reply with Quote
apply pagination on the page. use logic based on ROW_NUMBER function

http://www.codeproject.com/Articles/12338/Using-ROW_NUMBER-to-paginate-your-data-with-SQL-Se

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

adbasanta
Posting Yak Master

120 Posts

Posted - 01/03/2013 :  00:25:56  Show Profile  Reply with Quote
Thank you visakh16!

The link is very helpful.Ill post the query soon and post here back the result!


-------------------------------------------------------------------------------------------------------
Learning MS SQL Server 2008
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 01/03/2013 :  01:13:25  Show Profile  Reply with Quote
welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000