Saturday 31 August 2013

Copy only records that do not exist in the target table

Copy only records that do not exist in the target table

Having two tables (the source and target) intend to copy only the records
from the source table that do not exist in the target table (making the
comparison with the value of a specific cell in each record). I thought to
do it using arrays, but as I am new in this area, needed help.
Examples:
Source Table
ID Date Description
115 01-Ago Description1
120 05-Ago Description2
130 03-Ago Description5
110 08-Ago Description4
105 06-Ago Description6
Destination Table
ID Date Description
130 03-Ago Description5
110 08-Ago Description4
I want to add in the target table records from the source table that do
not exist in the target table (ID's 115,120,105 in this example). Thank
you!

No comments:

Post a Comment