I have source table called customer. And data from this table is transfered to another database with same table name.
that is database1(customer table) ----> database 2(customer table)
now in database 2, First time my program runs and it randomly get any name and ssn and then updates the first name, last name, ssn of all the customer_ID's in the customer table (I use RAND function)
Now second when i run the program, it recreates the name and ssn again but different, for the same customer_id.
So i want that once the particular customer_ID is updated, next time if i run the program. it shold not update the those updated customer id's
Thanks, Any help is appreciated.
View Complete Post