WITH MonthlyFee AS ( SELECT SUM(fee) AS MonthlyFees -- Query to calculate monthly fee percentage FROM Fee ), RemainingFee AS ( SELECT SUM(fee) AS RemainingFees -- Query to calculate Remaining Fees percentage FROM Invoice ) SELECT MonthlyFees,RemainingFees FROM MonthlyFee, RemainingFee;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)