I want to generate an unique 15 digit sequence number with prefix.
eg: TR0000000000001 , TR0000000000002 , TR0000000000003..............TR0000000000015,................TR0000000000250
I will start from 1 and then append the required prefix at the First 2 characters(TR). I want to append Zeros to make a 15 digit number.
I will store the last increment number in table and then add 1 and store it again during next generation.
My table will contains these are fields SequenceID,SequenceType,NextNumber and Prefix.Can you all suggests the best way to achieve this.