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