Posted by Doug on 03/09/06 03:37

>ORDER BY is valid in views only when used in conjunction with TOP

but if i have an order by in a view, without the TOP, it compiles.

Therefore, it is a bug.

As an example, If I use "sum" without a group by phrase, it won't
compile.

• Next in forum: Re: Query Brain Teaser - Revenue Projections
• Prev in forum: Re: Getting list of recently added IDENTITY items
• Thread view: Re: ORDER BY in VIEW not working

[Reply to this message]