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 |
|
Eagle_f90
Constraint Violating Yak Guru
424 Posts |
 Posted - 2008-01-25 : 17:00:14
|
| If you remember I asked a good way of spliting the result sets from a table into pages here: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=96063I got the great answer of using RowNumber. On doing a bit of searching on how to figure out how many pages to link though I keep coming up with referances to ADO's pagging system but no explicit way of reading it. Can anyone give me advice on finding out how many total pages the data got split into? The main script is in perl so via perl or T-SQL will work.-- If I get used to envying others...Those things about my self I pride will slowly fade away.-Stellvia |
|
|
|
|
|
Reading ADO's Paging.