Link to home
Start Free TrialLog in
Avatar of mainrotor
mainrotor

asked on

Need help using sum in a SQL query

Hi Experts,
I have a table in my SQL Server 2008 db that holds payment records. My table currently stores about 250,000 records.  Some of the columns in my table are PaymentType, PaymentCode, and PaymentAmount.  I want to get a sum of the PaymentAmount based on the various PaymentType and PaymentCode groupings. Do I need to use a Case Statement?  How can I accomplish this?  Below is a sample of the raw data, and what I want the out should be.  Thanks in advance.

Raw Data Sample:
PaymentType      PaymentCode      PaymentAmount
CR            PD            $10.00            
CR            FI            $35.12
CR            FI            $23.99
CR            PD            $25.20
CR            PD            $20.00      
CR            PD            $35.00      
HE            CH            $40.00
HE            CH            $15.00


RESULT SHOULD BE:
PaymentType      PaymentCode      Total            
CR            FI            $59.11
CR            PD            $90.20
HE            CH            $55.00

Thank you,
mrotor
SOLUTION
Avatar of Simone B
Simone B
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Ron Malmstead
Ron Malmstead
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial