UPDATE (Transact-SQL) - MSDN - Microsoft

The CTE result set is derived from a simple query and is referenced by UPDATE statement. Common table expressions can also be used with the SELECT, ...

msdn.microsoft.com