@ByronOne,
 Post the working code for the benefit of others please.

It would be easier to use Excel, PowerBI or some other method from Excel. A Macro could be written to update the spreadsheets.

Update the code in stored procedures to log this.

Are you running SQL Server 2012? If so the best way to track DML changes would be to add columns for validFrom and validUntil, updateSUser. Then add update and delete...

Sequential instead of parallel?

You will need to use dynamic SQL.

DECLARE @sql nvarchar(4000);
SET @sql =
'WITH CTE_Base
AS
( SELECT Cast(XIV.[decmes

I'm not clear what you're trying to do. Can you restate the question? Please post according to forum netiquette. If you do that you will likely get faster and...

Add a created-on column to each table. Create history tables with the same structure as the tables you want to audit and add a valid-from datetime2(7), a valid-until datetime2(7) and...

Please post properly

I would create a history table and an update, delete trigger that inserts deleted along with user and datetime of the edit.

Does the login have connect on it's default database or the database specified in the connection string it's using?

Please post consumable data