Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Cindy,
Thanks...what I'm trying to do is to create a cursor in which to display all data about a court case...with the most recently assigned AAG in a column, so that the user can sort on that column.
Ideally, I wanted some nice, neat, SQL to create a cursor of AAGs to incorporate into the rest of the data...other ways I can think of is to create the SQL w/an empty field, then SCAN and fill in the AAG (using some index as you suggested)...but w/so many records, that's too slow.
Oc, the method suggested by Bill works.
Thanks for your input....J
Précédent
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