I have a table that has records that already have unique numbers. I'm appending new records in from another table, but I'm trouble with an indexed field that needs to have an unique number, I need to take the max number from a certain record set,(ie. any record that has a sysid of M), that appears in the appended table and increment that number until all the records are appended.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need to update fields with non repeating numbers
- Thread starter rjmdt
- Start date
- Status
Similar threads
- Locked
- Question
- Locked
- Question