Post reply

Generate random number

  • August 21, 2008 at 9:17 am

    #861352

    Ofcourse you are correct i dont want to generate random numbers i want to generate sequential numbers for each unique vendor-company combination that arrives.

    Thanks

    Chandru

  • August 21, 2008 at 1:46 pm

    #861511

    Chandru,

    This kind of problem has been discussed many times on this forum. You should search for 'generating sequence numbers' or similar terms.

    You will need to evaluate the type of solution based on:

    1. the maximum rate at which you need a new vendor-company-sequence value, i.e. is it once every 5 minutes or 100 times every second; this will determine to some extend whether you will need to use BEGIN TRANS/COMMIT on a single table or possibly some simpler solution;

    2. multiple tables, i.e. one table for just the sequence and one (or more) tables for the detailed data;

    Hope this is useful.

Viewing 2 posts - 31 through 31 (of 31 total)

You must be logged in to reply to this topic. Login to reply