Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Finding Last Dash Number
Versions des environnements
Network:
Windows 2000 Server
I need a Select statement to find the last dash number in a series of partnumbers. Each record in my table has a unique sequence number. The table contains all partnumbers. The greatest sequence number represents the last partnumber that was entered and thus will be the last or greatest dash number for that series. So I need to isolate a series of partnumbers, records where the first six numbers are the same, then figure out from the dash suffixs(-401, -403, -405) which is the greatest.
The table is accessed remotely by SPT.
This is needed to control what the next dash number the user can create is.
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