tsql - Update a table using JOIN in SQL Server? - Stack Overflow

You don't quite have SQL Server's proprietary UPDATE FROM syntax down. Also not sure why you needed to ...

stackoverflow.com