View showing different results in preview vs the view

I'm not sure what is happening here. I have a view setup to order by 1
column then a 2nd which happens to be the key rec as it's the only field
where every cell is unique. In the Preview it orders the data properly by
the column I want then by the key rec. However the main view is ordered by
the Key rec still and no different than my table. I've checked and based on
the preview and criteria it looks good. I'm using SQL 2005 Dev version at
the moment to try and get some testing done before taking the data live.

Achase,

I am afraid that what you are seeing and what is happening are only
coincidentally matching your expectations. The BOL say that an ORDER BY in
a view will not guarantee an ordered result. See:

http://msdn.microsoft.com/en-us/library/ms188385.aspx
"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
by 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."

RLF

"Achase" wrote in message

> I'm not sure what is happening here. I have a view setup to order by 1
> column then a 2nd which happens to be the key rec as it's the only field
> where every cell is unique. In the Preview it orders the data properly by
> the column I want then by the key rec. However the main view is ordered
> by
> the Key rec still and no different than my table. I've checked and based
> on
> the preview and criteria it looks good. I'm using SQL 2005 Dev version at
> the moment to try and get some testing done before taking the data live.