|
|
Posted by Erland Sommarskog on 12/16/06 10:50
Russ Rose (russrose@hotmail.com) writes:
> "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
To clarify David's post: on SQL 2000 the above appears to work. That is,
if you say "SELECT * FROM Table1" the data comes back in the same order as
the ORDER BY clause most of the time. However, that is mere chance, and in
SQL 2005 it does not happen that often at all.
Logically the TOP 100 PERCENT and the ORDER BY means nothing at all.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|