Posted by Russ Rose on 12/19/06 00:35

"David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
news:1166260108.097369.244780@16g2000cwy.googlegroups.com...
> Russ Rose wrote:
>> "Hurricane" <mgreenway@gmail.com> wrote in message
>> news:1166213549.389511.148520@t46g2000cwa.googlegroups.com...
>> > When I create a view in SQL and include an ORDER BY clause i can see it
>> > in Management Studio. However, when I call the same view from an ASP
>> > page the order goes completely haywire.
>> >
>> >
>> > Any ideas?
>> >
>>
>> Does your view specify TOP 100 PERCENT?
>>
>
> 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...

>
> --
> 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]