daveh33 Posted March 25, 2008 Share Posted March 25, 2008 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? Quote Link to comment https://forums.phpfreaks.com/topic/97779-assistance-needed-converting-mysql-script-to-use-mssql/ Share on other sites More sharing options...
mikemessiah Posted April 22, 2008 Share Posted April 22, 2008 I am looking for that same thing... did you ever find a resolution? Quote Link to comment https://forums.phpfreaks.com/topic/97779-assistance-needed-converting-mysql-script-to-use-mssql/#findComment-524359 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.