Monday, February 18, 2002 12:50 AM
Well, there are a number of paths that you can go down to solve this problem. The quickest way, and the one most likely to make any DBAs happy is to use a seperate table that will serve as a counter for the numeric portion of your id. the key is not to use IDENTITY columns since they are prone to "gaps" that are a pain to fix. With a sequence number table, you can fix the sequencing very easily should anything go wrong.