473,382 Members | 1,204 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

Problem with Sum.... Noobish.

2
Hey guys,

This is a noobish question I guess but here goes:

I am attempting to recalc some of our Payroll data from Detail. I am summing the total dollar figure from each deduction code for the Month of November so I can update other tables. My script looks like this:

SELECT prdh_ded, sum(prdh_empe_amt) AS TotalDed FROM prdedhis
WHERE prdh_emp = 87016
AND prdh_chk_date BETWEEN '11/01/2007' AND '11/30/2007'
GROUP BY prdh_ded, prdh_empe_amt

The issue is that for each Ded Code I want ONE total. What the script is doing is summing only if the AMT field is equal. So if I have 3 rows of code 10 with amounts 50, 50, 30. The output looks like this:

prdh_ded TotalDed

10 100
10 30

I want it to look like this:

prdh_ded TotalDed
10 130


I'm sure this is my lack of experience, Any help would be greatly appreciated.
Dec 17 '07 #1
2 1047
deepuv04
227 Expert 100+
Hey guys,

This is a noobish question I guess but here goes:

I am attempting to recalc some of our Payroll data from Detail. I am summing the total dollar figure from each deduction code for the Month of November so I can update other tables. My script looks like this:

SELECT prdh_ded, sum(prdh_empe_amt) AS TotalDed FROM prdedhis
WHERE prdh_emp = 87016
AND prdh_chk_date BETWEEN '11/01/2007' AND '11/30/2007'
GROUP BY prdh_ded, prdh_empe_amt

The issue is that for each Ded Code I want ONE total. What the script is doing is summing only if the AMT field is equal. So if I have 3 rows of code 10 with amounts 50, 50, 30. The output looks like this:

prdh_ded TotalDed

10 100
10 30

I want it to look like this:

prdh_ded TotalDed
10 130


I'm sure this is my lack of experience, Any help would be greatly appreciated.

try following query

SELECT prdh_ded, sum(prdh_empe_amt) AS TotalDed FROM prdedhis
WHERE prdh_emp = 87016
AND prdh_chk_date BETWEEN '11/01/2007' AND '11/30/2007'
GROUP BY prdh_ded
Dec 17 '07 #2
shrynn
2
....wow I swear I tried that, but got an error saying the amount must be in group by list....

Well it worked this time, Thank you VERY much!
Dec 17 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Bruce Davis | last post by:
I'm having a problem on windows (both 2000 and XP) with a multi-threaded tkinter gui application. The problem appears to be a deadlock condition when a child thread pops up a Pmw dialog window in...
11
by: Kostatus | last post by:
I have a virtual function in a base class, which is then overwritten by a function of the same name in a publically derived class. When I call the function using a pointer to the derived class...
0
by: Refky Wahib | last post by:
Hi I need Technical Support I finished a Great project using .Net and SQL Server and .Net Mobile Control My Business case is to implement this Program to accept about 1 Million concurrent...
117
by: Peter Olcott | last post by:
www.halting-problem.com
28
by: Jon Davis | last post by:
If I have a class with a virtual method, and a child class that overrides the virtual method, and then I create an instance of the child class AS A base class... BaseClass bc = new ChildClass();...
6
by: Ammar | last post by:
Dear All, I'm facing a small problem. I have a portal web site, that contains articles, for each article, the end user can send a comment about the article. The problem is: I the comment length...
16
by: Dany | last post by:
Our web service was working fine until we installed .net Framework 1.1 service pack 1. Uninstalling SP1 is not an option because our largest customer says service packs marked as "critical" by...
2
by: Mike Collins | last post by:
I cannot get the correct drop down list value from a drop down I have on my web form. I get the initial value that was loaded in the list. It was asked by someone else what the autopostback was...
2
by: los117 | last post by:
I am trying to fetch email from gmail, but what I am really interested is the attachment. I manage to access the gmail server and get the messege but the attachment came as text: ...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.