Dazza051197
asked on
updating a table with values from another table
Can someone provide me with the sql which will update the records in table 1 with the records from table2 that are different, but columns 'ID' are equal in both tables. and also append any records from table2 that arent in table1.
I know the easiest way would be to delete from table1 then insert into table1 (select * from table2), but I don't want to enable the select into option on the database because it doesn't use the transaction log.
Daz
I know the easiest way would be to delete from table1 then insert into table1 (select * from table2), but I don't want to enable the select into option on the database because it doesn't use the transaction log.
Daz
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER