Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
INDEX ON....IIF(x,'ASCENDING','DESCENDING')
I'm trying to create an index that will internally change back and forth between Ascending and Descending depending on the value of a field.
Let's say I have a table with the following fields and values.
cValue AorD
01 A
02 A
03 D
04 D
05 A
06 A
07 D
08 D
I want to index on cValue Descending but internally cValue would be subIndexed as either Ascending or Descending depending on the value of AorD so that the final index would produce the following result.
cValue AorD
01 A
02 A
04 D
03 D
05 A
06 A
08 D
07 D
Can anyone think of a way to do this even using UDFs if needed?
Ed
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement