title: Techniques for generating sequential numbers for table
body: <p>We are currently using a database table to manage the generation of sequential numbers to be used for many table.  Because this table is used by numerous other routines, we get a deadlock situation from time to time.  </p>
  
  <p>We would be interested to hear what other techniques can be use to generate sequential numbers for tables.  Each table will run a different sequential series for different company data within the table.</p>