Get inserted and update rows count from an SCD2 query

[juansandzeros]

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?

[NowinskiK]

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

[jwk6]

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.
#11