Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I am creating a cursor with a select statement. Several of my cursor columns are functions that scan a table based on the current cursor record info. Example: Field 1 is a drawing number. This drawing number can be associated with many Data Submittal Index Numbers which we call EDR's. The edr data info is in a seperate table. In a given record I want to know the maximum date that a submittal was made on any affected EDR, who is responsible for this submittal, what is the EDR description, etc. The only way I know to get each one of these pieces of info into a column is to have funtions for each. This means the table is scaned over an over which makes it slow to generate the cursor. Please let me know if there is another way.
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