Posted by David Portas on 12/19/06 07:36

Russ Rose wrote:
> > If it does then the OP should remove it and the ORDER BY clause. TOP
> > 100 PERCENT is redundant and misleading. It achieves nothing useful.
>
> Other than returning the rows in the desired order that is...
>

Evidently not.

--
David Portas, SQL Server MVP

Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.

SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

[Back to original message]