Hello all,
I'm connecting to MS SQL 7 via perl using DBD:ODBC and openlink. I'm
returning massive amounts of data through it which and its slowing the
loading of webpages down massively so I don't want to use the perl to cut
off the first however many results when I go to a next screen. (for example
results 1-20, then 21-40, 41-60)
I know that in MySQL there is a LIMIT Clause (LIMIT 21,30). MS SQL however,
appears to have no equivalent that I have found. Does anyone know
differently or have an answer for this problem? The only other I've found
suggests using unique ID numbers and using a TOP 20 where number > 20.
Which won't work because of how this searches. Thank you for your time.
Justin Kelley
