Batch update:
Update SellRecord set sr_productioncode = p_code from production where sr_Production = p_name