Quite often, you may see this warning message when you use MERGE statement.
If you get this, then your Merge statement is trying to update multiple rows in "WHEN MATCHED" Clause.
Multiple updates to the same row in destination table is NOT allowed.
Multiple insert is allowed though.
To know for sure, If you comment out your "WHEN MATCHED" section, you will no longer get this warning.
No comments:
Post a Comment