使用Case语句更新另一个表

I have a table with one record in it. I need to update 8 fields in another table based on the TYPE column of the one record. I thought a Case statement was the way to go, but I am pulling my hare out! I have searched and seen some examples that come close BUT not quite! any help please! here is my code.I have a table with one record in it. I need to