select A, B, C, into #temptable from Table1
where ID in (1,2,3)
update Table2
set Table2.C=#temptable.C,
from #temptable
where Table2.A= #temptable.A and Table2.B= #temptable.B
drop table #temptable
select A, B, C, into #temptable from Table1
where ID in (1,2,3)
update Table2
set Table2.C=#temptable.C,
from #temptable
where Table2.A= #temptable.A and Table2.B= #temptable.B
drop table #temptable