i have data of 100 records in one server with table name Population
and i have data 50 records of same table name in another server.if is sp_generate_inserts for that i need to delete data and again insert.But here i want to update as well as insert new records in mean time..suggest me
========================================== Cursors are useful if you don't know sql. SSIS can be used in a similar way. Beer is not cold and it isn't fizzy.