This proc is awesome as I've used it in the past; however, seems to have issues with SQL Server v2019. (I am using an unaltered version of sp_generate_merge). Any assistance is greatly appreciated. I ...

When using MERGE together with CTE on SQL Server I get the error complaining about a missing semicolon after the MERGE statement but the query executes successfully when selected manually but fails ...