RoundRobin update of a table from a second table
Posted on 2012-04-02
I have a requirement to create 10 calls per day (Calendar records) each, for a group of Users from a second table in the database CONT1.
I have a table with the user's USERID in table USER.
I have extracted 10 x the number of current users records from CONT1 as MAKECAL, marking CONT1 as having been used (extracted)
I need to be able to populate the USERID field in the MAKECAL table with USERID from USER table until all the records in MAKECAL have a USERID. It does not have to be in any order, random order is fine; but a roundrobin update would make more sense.
All assistance is appreciated