Union and Order By in a View

I have coded a view that uses a Union and an Order By. When I execute the
query by itself, it works fine. When I select * from the View, even though
the full result set is returned, the results are not returned in the order
specified in the Order By.
Also, when I attempt to modify the View, I get a message window that says
"Unable to parse query text". I click OK and it opens the Query Designer
just fine.

Stan,

The reason is as described in this link for SQL Server 2005 (and still true
in 2008):
http://msdn.microsoft.com/en-us/library/ms187956(SQL.90).aspx
The ORDER BY clause does not guarantee ordered results when the view is
queried, unless ORDER BY is also specified in the query itself.

The Designers in SQL Server Management Studio have several problems.
Generally, it is wiser (safer) to edit the script yourself. That way you
stay in full control of what happens.

RLF


"Stan G." wrote in message

>I have coded a view that uses a Union and an Order By. When I execute the
> query by itself, it works fine. When I select * from the View, even
> though
> the full result set is returned, the results are not returned in the order
> specified in the Order By.
> Also, when I attempt to modify the View, I get a message window that says
> "Unable to parse query text". I click OK and it opens the Query Designer
> just fine.