To perform an UPDATE from a SELECT in SQL Server, you can use a subquery or a common table expression (CTE) to select the data for the update. For simple updates, use a subquery with INNER JOIN. For more complex scenarios, use a CTE with aggregate functions. You can also capture updated values using the OUTPUT clause. Always test on non-production data first.