T-SQL update table A with values from table B (hard coded)

Question

I have table A, where I have 164 distinct values for column CODE as follows:

Code
May-Update-DTO
Terminated
Breaking
One-Two-One
"None"

etc

I also have a CSV file where all of these codes above are mapped to a different values that our software understands:

May-Update-DTO --> None Shift
Terminated --> Value Time
Breaking --> None Dom
One-Two-One --> POE Exec
"None" --> Manual

I have to essentially source this CSV file and update table A per the CSV values above. I can potentially load these CSV files into a local table. What would be the best way to accomplish this? CSV file has like 250 records.

Thank you for any ideas!

Answer 1

If you load your CSV into a table, you can do a simple UPDATE with JOIN

UPDATE a
SET Code = csv.NewCode
FROM TableA a
JOIN CsvTable csv ON csv.Code = a.Code;