UPDATE some_table SET some_row = another_row,some_row2 = another_row/2 FROM some_table st CROSS APPLY (SELECT TOP 1 another_row FROM another_table at WHERE at.shared_id=st.shared_id) WHERE ...