Posted by Beowulf on 01/03/07 15:51

Russ Rose wrote:
> "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...

Even with TOP 100 PERCENT and ORDER BY, that's not guaranteed, which I
learned the hard way. In SQL Server, views are not ordered and it is an
error to depend on them being so.

[Back to original message]