update table1
set firstname = (select top 1 firstname from table2 order by NEWID())
update table1
set firstname = (select top 1 firupdate table1
set firstname = (select top 1 firstname from table2 order by NEWID())
update table1
set firstname = (select top 1 fir