Solved

Need help using sum in a SQL query

Posted on 2013-06-20
2
374 Views
Last Modified: 2013-06-20
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
0
Comment
Question by:mainrotor
2 Comments
 
LVL 11

Assisted Solution

by:Simone B
Simone B earned 250 total points
ID: 39263563
Try this:

SELECT PaymentType, PaymentCode, Sum(PaymentAmount) as Total
from PaymentRecordsTable
Group by PaymentType, PaymentCode

Open in new window

0
 
LVL 25

Accepted Solution

by:
Ron M earned 250 total points
ID: 39263564
SELECT PaymentType ,     PaymentCode,     SUM(PaymentAmount) as PaymentTotal
FROM YourTableName
GROUP BY PaymentType, PaymentCode


..try that.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now