Posted by Rick on 09/26/05 19:01

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]