Posted by Dan Guzman on 09/26/05 19:37

Ordering of results is guaranteed only when you specify an ORDER BY clause,
regardless of any indexes you have on the table. As Simon indicated, you
need to specify ORDER BY for your ordering requirement.


--
Hope this helps.

Dan Guzman
SQL Server MVP

"Rick" <rick@abasoftware.com> wrote in message
news:1127750481.808920.194390@g49g2000cwa.googlegroups.com...
> The relevant table structure is
> col 1 -type datetime
> col 2 -type int
>
> In Enterprise manager, I've created a two column clustered index
> with col 1 as the first column of the index in desc order
> and with col 2 as the second column of the index in asc order
>
> When I open the data, for a common date, it orders the data
> 1,10,100,2,20,200 etc.
> Rick
>

[Back to original message]