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

• Next in forum: Re: View Order Dissappearing
• Prev in forum: Re: Performance Difference between SQL Server 2005 Standard Edition and Enterprise Edition
• Thread view: Re: View Order Dissappearing

[Reply to this message]