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