USE T19S002

UPDATE bill_detail SET DispFromCityName = ISNULL(DispFromCityName,''), DispFromCityPIn= isnull(DispFromCityPIn,(select compcitypin from company_detail where compcode = 'T19S002'))

DELETE FROM company_detail WHERE COMPCODE <>'T19S002'