"as shown in the Venn diagram in Figure 5" should this be Figure 3?

"INNER JOIN operation to return part 2 of Figure 6" should this be Figure 4?

A very clear and informative article. A minor point is that the Figure numbers appear to be incorrect in the INNER Join Operator and OUTER JOIN Operator sections

Nice idea.

I have used xp_cmdshell to pipe debug to logfile when transactions fail

declare @msg varchar(255)

set @msg = 'echo ' + 'debug text here' + ' > c:\log.txt'

exec...

With Rollup can be replaced with Rollup

SELECT

Product_Name,

Scheme_Name,

Invest_Amount,

broker_commission,

-1 AS IsSchemeTotal,

-1 as IsGrandTotal

FROM @GroupTest

Union ALL

select

isnull(Product_Name, 'ZProductTotal'),

isnull(Scheme_Name,'ZTotal'),

sum(Invest_Amount),

SUM(Broker_Commission),

GROUPING(Scheme_Name) AS IsSchemeTotal,

GROUPING(Product_Name) AS IsGrandTotal

from @grouptest

group by rollup (Product_Name,Scheme_Name)

ORDER BY Product_Name,

Scheme_Name,

IsSchemeTotal,

IsGrandTotal

To...

An alternative is to use a temp table created by the proc which will be visible to the trigger

You can check for the existence of an identity column and then exclude it from the insert list as well as not altering the temp table definition

The insert statement...

{call cp_reportConsult(?,?)} in SQL pane of Microsoft query.