I am re-keying the State Province records into the StateProvince table.
I re-keyed 4 records and reran query. Now those records are being updated correctly.
Visually they all look right, so I am not sure why re-keying over the state code in the table is causing the records to now be updateable. ???????????????????????????????????????????????
I will let you know if this is all fixed after I re-key all records.
Update s
SET s.StateName = sp.StateProvinceDesc
FROM #State s
INNER JOIN StateProvince sp
ON s.StateCode = sp.StateProvinceCode