Tag: tsql

UPDATE Table1 SET SomeColumn = X.SomeOtherColumn FROM Table1 T1 CROSS APPLY (SELECT TOP 1 SomeOtherColumn FROM Table2 T2 WHERE T2.SomeJoinColumn = T1.SomeJoinColumn ORDER BY CounterColumn) AS X I want to…