Yes. I am aware of Go statement but here I am not using any batch terminator.

Declare @Myvar Tab(Id int, Latesttime DateTime)

Insert into @Myvar (Id, LatestTime)

(select Id, Latesttime from TableA A join TableC C where A.Name=C.Name....)

Update @Myvar

SET V.LatestTIme=B.LatestDate

FROM TableB B

INNER JOIN @Myvar V

ON V.id=B.ID