|
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
Navigation:
[Reply to this message]
|