Need a query for updating records to retain existing keys based on certain condition in sql table.

Hi, I need sql query to perform below task. We have one retailer table has demographic information of retailers like ..     And as RETAILER_KEY is BIGINT identity column and we want to keep...