As our outsourcing team just was made aware.. if you have temporary incrementing numbers in a data set that are constrained to be unique for the love of god increment them negative! If you have more than one person inserting into an auto incrementing table in a database and you return the actual database unique number and that is part of your list of temporary number bad things happen.