UPDATE Table1 set SomeColumn = X.SomeOtherColumn from Table1 T1 cross apply (select top 1 SomeOtherColumn […]