Posted by Rick on 09/26/05 20:20

I'm not so sure it isn't a bug.
Here are some observations.
If I write a select statement like
'Select * from mytable order by datecolumn, intcolumn', the int column
order is correct.
If I write a select statement like
'Select * from mytable order by datecolumn desc, intcolumn', the int
column order is not correct.
This parallels the (mis) behaviour of the clustered index.
Is there a logical reason for this or is this a bug?

[Back to original message]