Added another script for the taxes: { "mScriptID": "3141", "mName": "Latest Tax Script", "mScript": "ALTER PROCEDURE FixAllTaxes @StartDate DATETIME AS BEGIN SET NOCOUNT ON; DECLARE @MyCursor CURSOR; DECLARE @TransactionID AS INT; BEGIN SET @MyCursor = CURSOR LOCAL FAST_FORWARD FOR (SELECT T.TransactionID FROM SdTransactions T WHERE T.Tax1Perc NOT IN (SELECT TX.Percentage FROM SdlTaxes TX WHERE TX.IsActive=1) AND T.Tax1Perc NOT IN (SELECT TX.RulePercentage FROM SdlTaxes TX WHERE TX.IsActive=1 AND TX.RuleActive=1) AND T.DateCreated >= @StartDate) OPEN @MyCursor FETCH NEXT FROM @MyCursor INTO @TransactionID WHILE @@FETCH_STATUS = 0 BEGIN DECLARE @taxID AS INT; DECLARE @taxPercentage AS DECIMAL(18,2); DECLARE @taxAmount AS MONEY; SET @taxID = (SELECT T.Tax1_TaxID FROM SdTransactions T WHERE T.TransactionID=@TransactionID); SET @taxPercentage = (SELECT TX.Percentage FROM SdlTaxes TX WHERE TX.TaxID=@taxID); if(@taxPercentage > 0) begin SET @taxAmount = (((SELECT T.Amount FROM SdTransactions T WHERE T.TransactionID=@TransactionID) * @taxPercentage) / (100 + @taxPercentage)); UPDATE SdTransactions SET Tax1Perc=@taxPercentage ,Tax1=@taxAmount WHERE TransactionID=@TransactionID; end FETCH NEXT FROM @MyCursor INTO @TransactionID END; CLOSE @MyCursor; DEALLOCATE @MyCursor; END; END;" }, { "mScriptID": "3142", "mName": "Execute Latest Tax Script", "mScript": "EXEC FixAllTaxes @StartDate =''2020-09-01 00:00:00.000'';" }