Open View from SQL Server Management Studio

Why the order is lost when I Select Open View??

My query really includes an ORDER clause and the Execute query was fine.

Hi

From BOL:
When ORDER BY is used in the definition of a view, inline function, derived
table, or subquery, the clause is used only to determine the rows returned b
y
the TOP clause. The ORDER BY clause does not guarantee ordered results when
these constructs are queried, unless ORDER BY is also specified in the query
itself.

You don't say if you are using SP1 or not, there are issues with ORDER BY
when in SQL 2000 compatibility mode.

John

"515331Jack3490" wrote:

> Why the order is lost when I Select Open View??
>
> My query really includes an ORDER clause and the Execute query was fine.
>
>
>