From: Gerry Hickman on
"Tibor Karaszi" <> wrote in
message news:emq52k5uKHA.5936(a)TK2MSFTNGP04.phx.gbl...

Thanks Tibor, there's a lot of explanation in this blog.

> --
> Tibor Karaszi, SQL Server MVP

From: Plamen Ratchev on
In addition to the other comments, BOL has this explained very well:

The ORDER BY clause is used only to determine the rows that are returned by the TOP clause in the view definition. The
ORDER BY clause does not guarantee ordered results when the view is queried, unless ORDER BY is also specified in the
query itself.

Plamen Ratchev