Create an ascending numberic value.
Posted on 2008-10-10
I receive voucher data with around 200,000 - 1,000,000 records and need to build tables for processing. The only data I receive is a random ascending voucher or coupon Id Like so....RDP000333555. Based on how many of these vouchers will be placed in a sample kit...5 or 10 etc..I need to build a control number. The example is based on 55,000 records with 5 per kit with equals 11,000 kits. This example is the first kit.
Vouchers: Voucher ID Kit Control Number
(Individual vouchers) (numer on the outside of the kit)
RDP000000001 000001A 000001
RDP000000009 000001B 000001
RDP000000128 000001C 000001
RDP000002223 000001D 000001
RDP000003698 000001E 000001
Some of these jobs run together and I need to start the numbers at a different point instead of always at 000001. Also I need these padded with "0" to 6 Positions.
What I would like to have is fill out a form with the amount of vouchers per kit and the starting number and have the code generate and attach the numbers to the vouchers.
Records to process: 200,000
Vouchers Per Kit: 5
Starting Number: 000001
Thanks in advance.