Import/update from one table to onother ?
Posted on 2012-03-22
Have used BULK INSERT, and inserted about 85000 records
But need to insert/update from table1_tmp to a existing table ->table2
if record exist in table2, it must update table2
if record not exist it must insert the new record to table2
Whaqt is the fastest way to do this, using stored procedure ?
Please give me example of this