This is an important blog post about the limitations in TSQL update when you join with other tables.   Seems like I have used this TSQL "enhancement" myself without knowing the limitations.   The blog post points to the new merge statement in SQL Server 2008 and some other solution.   There is another non-ANSI …

Read more »