I suppose that you use ORDER BY in a subquery.
This is not admitted without use of TOP clause (SQL Server).
If you need all rows from subquery, you can use this trick
<pre>SELECT TOP 100 PERCENT
Register Hereor login if you are already a member