Activity overview
Latest activity by Matt Benham
Automatically build MERGE statements that synchronise content between two similar or identical table schemas (or a source CTE). The “WHEN MATCHED AND … THEN UPDATE SET …” is especially painful and verbose. I usually construct the SQL using Excel formula. I'm sure I can't be the only person with a use-case for merge statements to efficiently synchronise live tables from staging tables? Any solution would need to handle changes in nullable columns that have changed to or from null values. / comments
Automatically build MERGE statements that synchronise content between two similar or identical table schemas (or a source CTE). The “WHEN MATCHED AND … THEN UPDATE SET …” is especially painful and ...