Assistance needed converting MySQL script to use MSSQL

[daveh33]

I have a data management system which was previously configured to use a MySQL database..

 

As the database has expanded it doesn't seem to be able to cope with the amount of data - so I am transferring it to a MSSQL database.

 

Most of the move has been pretty straight forward but I am having problems with one query: -

 

$result=mysql_query("SELECT DISTINCT(number)
FROM  $tablename WHERE NOT EXISTS (
    SELECT DISTINCT(number)
    FROM dbo.STOPS 
    WHERE $tablename.number=dbo.STOPS.number
) 
LIMIT $start,$finish") or die(mysql_error());

 

I am aware that is MSSQL there isn't a LIMIT function... but I dont know an alternative? Any ideas?

[mikemessiah]

I am looking for that same thing... did you ever find a resolution?