Posted by Serge Rielau on 12/15/06 20:53

Hurricane wrote:
> When I create a view in SQL and include an ORDER BY clause i can see it
> in Management Studio. However, when I call the same view from an ASP
> page the order goes completely haywire.
Good! views aren't called, they are selected from.
When you issue a SELECT it only has an ORDER if you specify it for that
SELECT.
Any order specified inside the view definition is irrelevant. Only TOP
cares for nested ORDERs

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

WAIUG Conference
http://www.iiug.org/waiug/present/Forum2006/Forum2006.html

[Back to original message]