Re: "LIMIT" problem MSSQL

i assume this problem was solved in the past.... i didn't found a ready solution. i try to use FATCH . and i have another link with ths same problem.. http://forums.devshed.com/showthread.php?threadid=33114 tnx noam "John Krewson" <krewsonj@sworps.utk.edu> wrote in message news:3E539F00.2010202@sworps.utk.edu... > The title suggests MSSQL, which if I am correct doesn't support Limit > like MySQL. > > I'm working on the same thing right now so I don't have a quick and > dirty working example, although it doesn't look to be too difficult to > use server side cursors in MSSQL. > > Here is a related a link to a similar question at phpbuilder: > http://www.phpbuilder.com/mail/php-db/2001062/0055.php > > Snijders, Mark wrote: > > $start = 10; > > > > $numbers_to_show = 25; > > > > $sql = "SELECT * FROM bla Limit $start, $numbers_to_show"; > > > > or just go to mysql.com and use the manual :) > > > > -----Original Message----- > > From: Noam Giladi [mailto:noam@i-com-it.com] > > Sent: woensdag 19 februari 2003 16:00 > > To: php-db@lists.php.net > > Subject: [PHP-DB] "LIMIT" problem MSSQL > > > > > > I'm trying to split results into different pages and number the pages > > accordingly. I've been able to build a fairly intelligent page numbering > > system which knows which rows it should pull (at least by numbering each row > > numerically) but I don't know how to construct a SQL query to pull 10 > > results starting at a certain number. > > > > please did anyone wrote a proc that do it?. > > > > > > > > > > -- > John Krewson > Programmer - SWORPS >