Adding a summary row with totals

[Halliarse]

Hi

I have the following stored procedure and I need to add a summary line with totals on the following fields:

BTARevenue
DrillRevenue
GRDRevenue
HoneRevenue
Unit1Revenue

The stored procedure is attached.

Any help would be gratefully accepted!

Kind regards

Steve

 

[Olaf Doschke]

That's really something a report should add or Excel or GRid you use for disaplay and not already the stored procedure.
Don't solve that in the query code.

Bye, Olaf.

Olaf Doschke Software Engineering

https://www.doschke.name