Posted by Russ Rose on 12/15/06 23:57

"Hurricane" <mgreenway@gmail.com> wrote in message
news:1166213549.389511.148520@t46g2000cwa.googlegroups.com...
> 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.
>
>
> Any ideas?
>

Does your view specify TOP 100 PERCENT?

CREATE VIEW dbo.OrderByDateView

AS

SELECT TOP 100 PERCENT Field1, Field2, Date1
FROM Table1
ORDER BY Date1

[Back to original message]