So as an example you can do things like:

declare @id int,

declare @myVar nvarchar(10)

select @id = [id],

@myVar = [myColumn]

FROM Table1

Update Table2

Set MyColumn = @myVar

Where ID = @id