Posted by David Portas on 12/16/06 09:08

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.

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