SQL Get Totals

Korvanica · 10-05-2011 04:34PM #1

OK So i've the following Table:

And what I need to do is go through this table and get the total "TimeValue" for each instance that the "EmplNo" and "CodeDescNo" are the same.

So for example the first three lines, we have 6 and 7 as the first two columns, for each row. What I need to do is add up the "TimeValue" Column for these three instances and deposit the result in a new table which has the layout

EmplNo--CodeDescNo--Total
6--7--777
6--691--0
6--754--0
7--8--180

etc etc..

After messing about a bit i'm not very far, i'm guessing that a cursor may be needed?

Anyone have any suggestions?

Thanks.!

Beano · 10-05-2011 07:41PM

quite straightforward to do by grouping the select by the EmplNo and CodeDescNo columns

ocallagh · 10-05-2011 10:44PM

edit: I assumed Mysql... will leave answer below anyway - not sure of the INSERT INTO syntax for SQL Server

Use SUM to get the total time so sql would look something like:

SELECT SUM(time) as total, emp, code FROM table1 GROUP BY emp, code

And then to copy these result into a another table you would wrap this inside an INSERT INTO statement, eg:

INSERT INTO table2 (total, emp, code) SELECT SUM(time) as total, emp, code FROM table1 GROUP BY emp, code

Korvanica · 11-05-2011 10:09AM

Thanks all, got it sorted...Chances are ill be back with more sql questions :S

Only starting with it and have to face walls of SQL..

talk about deep end

amen · 11-05-2011 01:25PM

is this for work or college?
if work ask them send to you on a course

SQL Get Totals

Comments