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
 Development Tools
 Other Development Tools
 How to fetch n records from row i onwards ?

Author  Topic 

deshpandedn
Starting Member

1 Post

Posted - 2007-09-08 : 02:38:50
Hi there ,

I need to print 30 lines per page with page total at the end of each page. On the next page, the last page total should appear at the top as carried forward from last page. Next 30 records should be printed with same style.

I want to know what i have to do in SQL stored Proc. to fetch records in group of 30 ?

My front end is classic ASP.

Deepak

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-09-08 : 09:43:41
search for "paging" here http://www.sqlteam.com/search.aspx


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-09-08 : 10:26:18
or "pagination" in google

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2007-09-08 : 12:53:25
See also:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Efficient+paging+of+recordsets,Paging+in+SQL+2005

Kristen
Go to Top of Page
   

- Advertisement -