Posted by David Portas on 03/07/06 11:27

RickW wrote:

> I'm a
> bit ticked that a very useful feature, in place for almost a decade, was
> taken away without more reasonable notice. I would have thought it
> would show up on the MSDN page I quoted in an earlier reply.
>

Your unwillingness to learn is so amazing that I wonder why you
bothered to ask at all. There was no notice in the docs because no
feature was removed. It's just that you assumed the existence of a
feature that never was there. Even in SQL Server 2000 queries against
views containing ORDER BY don't always respect any predetermined order.
In many cases ORDER BY in views will be ignored. I believe that has
been true of every version of SQL Server. Your elementary mistake
reminds me of the joke about the economist who sees a brown cow and
therefore assumes all cows are brown.

I'd second Joe's suggestion: get some training. Trial and error is the
most expensive form of education.

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