I'm running SQL Server 2000. I need an sql query to add a row (similar to the grand total) to this query. Net deposit should add together the two fee columns and then subtract it from the rollup value.
Attached (current) is where I am so far....
My Goal is attached (goalview)
COALESCE (CAST(SubscriberID AS varchar(8)), 'Grand Total:') AS SubscriberID,
SUM(PaymentAmount) AS SubcriberTotal,
SUM(PaymentAmount) * 0.0289 AS CreditCardFee,
COUNT(PaymentID) * 0.30 AS TransactionFee
GROUP BY SubscriberID WITH rollup