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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-05 : 16:28:47
|
james writes "I have a site that has a search facility onto SQL server 7
Some searches produce 100s of results - they are given in pages of 15.
I need a way of getting results like this
Page1>> Results 1-15
Page2>> Results 16-30
etc
Page 1 is easy - use the TOP keyword
but Page2.... I need something (a stored procedure) that will accept a @startposition, @number of rows, @SomeCriteria arguments
ideally it needs to offer the same functionality that a MIDDLE keyword would offer
ps ADO pagesize functionality not supported by SQL server apparently
Any help would me much appreciated
James" |
|
|
|
|
|
We've got TOP, what about a keyword like MIDDLE?