SQL 2000 - Sum in a Group By

Working on an old SQL 2000 DB.
Having problem with a simple Select. Can someone give a quick hand

There are two number (Int) columns in the select. I need to group by 3 other fields.  The number fields are being selected as SUM().
If I include the number fields in the Group By, I get too many rows as most of the values are different.
If I exclude them from the group, I get error: 'Not in aggregate function or Group by'. Why does it not recognize SUM as an aggregate?
is it the column type?

Select
Field_A,
Field_B,
Field_C,
SUM(Num_A),
SUM(Num_B)
FROM MYTABLE
Group By Field_A, Field_B, Field_C
Order By Field_A

Open in new window

LVL 1
JDCamAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Can't understand the issue. The SELECT you provided should work fine.
Maybe if you post with some sample data I'll understand it better.
0
Brian CroweDatabase AdministratorCommented:
I don't see anything wrong with the query you posted if Num_A and Num_B are numeric.  Try providing an alias for the aggregate columns but otherwise I'm at a loss.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JDCamAuthor Commented:
Disregard.... just a silly typo i didnt notice
0
JDCamAuthor Commented:
thanks for looking... I will share the points
0
Brian CroweDatabase AdministratorCommented:
Points are always appreciated but it would also be acceptable to request that the question just be deleted.

Glad you got it solved
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.