UPDATE Table1
set SomeColumn = X.SomeOtherColumn
from Table1 T1
cross apply
    (choose prime 1 SomeOtherColumn from Table2 T2 the place T2.SomeJoinColumn = T1.SomeJoinColumn order by CounterColumn) as X

I need to improve CounterColumn by 1 every time the cross apply question runs. Is there any means I may obtain this?