Untitled

SQL: Update multiple rows
name      last_name
______    ________
James     abcasd
Becky     hadsfd
Richard   adfdfadgg

name      last_name
______    ________
James     Jamerson
Becky     Beckerdude
Richard   O'Nerdy

update yourTable set Last_Name = CASE When Name = 'James' then 'Jamerson'
                                 WHEN Name = 'Becky' then 'Beckerdude'..
                                 --then for each case
                                 END

select
'When Name = '''+CAST(Name as Varchar(50)+''' Then '''+Cast(LastName as Varchar(50)+'''
from yourTableWithRelation

Update yourTable set Last_Name = CASE
--Paste here the generated
END

Update T set T.Last_Name = T2.LastName from YourTableToUpdate T inner join TableWithNewLastName T2
on T1.Name = T2.Name