Copying data from a field in all records from a found set and placing it into another table
Hopefully you'll be able to provide me with some assistance or point me in the right direction.
Basically, we have 2 databases that are related by client ref, when a client sends his contract back, this date is added to Database A. We would like to run a script from database B that searches Database B for all records where this date field is empty. The script will then link back Database A (where the date will exist) and put the date into the relevant field on Database B.
Where we're stumbling is that there are circa 30000 records in database B where there is no date, I think we need to use some kind of loop so that it moves from record to record and adds the date for all records as it goes along.