SCD-Merge-Wizard icon indicating copy to clipboard operation
SCD-Merge-Wizard copied to clipboard

Published 20 hours ago • verified publisher icon Azure-Player

Get inserted and update rows count from an SCD2 query

Open juansandzeros opened this issue 4 years ago • 2 comments

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?

juansandzeros avatar Dec 01 '20 12:12 juansandzeros

Not yet. But thanks, this is a good shout!

NowinskiK avatar Dec 01 '20 13:12 NowinskiK

This is one of the reasons why I added the suggestion for templates. We would also need to provide an audit log table and a stored procedure, or some inline T-SQL to do the auditing. Definitely doable though. @juansandzeros You can see some of the code required to save row counts in the following enhancement suggestion.
https://github.com/SQLPlayer/SCD-Merge-Wizard/issues/11

jwk6 avatar Jun 01 '21 01:06 jwk6