SQL Server Error Code – 8672 the merge statement attempted to update

In this blog post, you’ll learn more about the SQL Server Error Code 8672 and the error message description that is shown

SQL Server Error Code

8672

SQL Server Error Description for the Code :8672

The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE statement cannot UPDATE/DELETE the same row of the target table multiple times. Refine the ON clause to ensure a target row matches at most one source row, or use the GROUP BY clause to group the source rows.

Leave Your Comment