Grouping a sum

Question

Post reply

Grouping a sum

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

Something like this?

SELECT Company, SUM([Pieces of Equipment])

FROM ...

GROUP BY Company

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

AVB SSChampion Points: 11418 More actions · Answer 2

Hmmm, that seems like it was too easy to really be worth posting on this site! Thanks it worked. I was making it way more complicated. Thanks again Chris!!!!!

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

Ninja's_RGR'us

SSC Guru

Points: 294069

April 18, 2005 at 9:02 am

#553203

Nothing's too easy or too hard for us .

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 4

Sounds like a line from The Incredibles or something.

But it's true, the only stupid questions are those that are not asked.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/