SQL Server Error Msg 11722 – NEXT VALUE FOR function is not allowed in the WHEN MATCHED clause, the WHEN NOT MATCHED clause, or the WHEN NOT MATCHED BY SOURCE clause of a merge statement.

In this blog post, let’s learn about the error message “11722 – NEXT VALUE FOR function is not allowed in the WHEN MATCHED clause, the WHEN NOT MATCHED clause, or the WHEN NOT MATCHED BY SOURCE clause of a merge statement.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

11722 – NEXT VALUE FOR function is not allowed in the WHEN MATCHED clause, the WHEN NOT MATCHED clause, or the WHEN NOT MATCHED BY SOURCE clause of a merge statement.

Reason for the Error

To be update soon…

Solution

To be update soon…