SCD-Merge-Wizard
SCD-Merge-Wizard copied to clipboard
Azure-Player
SCD Merge Wizard is an application which will help you generate T-SQL statement for merging data from two tables into one table in minutes. At the end, generated T-SQL statement can be used to replace...
Executing ScdMergeWizard.exe will result in the following if .Net Framework 3.5 is not installed. This is increasingly difficult to deal with, because most organizations do not have the group policy...
Add optional support for the EXCEPT operator in the WHEN MATCHED clause, as described here: http://www.made2mentor.com/2013/05/writing-t-sql-merge-statements-the-right-way/ For Example: WHEN MATCHED AND EXISTS (SELECT Source.Column1, Source.Column2 EXCEPT SELECT Target.Column1, Target.Column2) This...
Allow a user defined stored procedure template so that the developer can inject other T-SQL code around the merge statement. For example, I use Azure Data Factory to call a...
Is there a way to get the insert and updated rows count from an SCD2 query so they can be added to an audit log?
The MERGE statment generated doesn't allow to use tables in diferent databases. It would be nice to get an option to change the MERGE generated by a INSERT/UPDATE statment.
I happen to like what the Windows Terminal team does here - https://github.com/microsoft/terminal/blob/master/CONTRIBUTING.md#fork-clone-branch-and-create-your-pr **Fork, Clone, Branch and Create your PR** Once you've discussed your proposed feature/fix/etc. with a team member,...
Would be nice to have a robust installation file signed with a certificate instead of seeing that window when attempting to install the app from MSI file:  But the...
Metadata
Owner
Metadata
SCD Merge Wizard is an application which will help you generate T-SQL statement for merging data from two tables into one table in minutes. At the end, generated T-SQL statement can be used to replace...