Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 Query Help

Author  Topic 

aswindba1
Yak Posting Veteran

62 Posts

Posted - 2013-04-29 : 17:19:27
I need add multiple rows and take sum of that row in to single column


Server|||| Cost

abcd ||||| 75
abcd ||||| 25
dtgr ||||| 65
dtgr ||||| 35

table should lok like below.

Server||||| Cost
abcd ||||| 100
abcd ||||| 100
dtgr ||||| 100
dtgr ||||| 100

or

abcd |||||100
dtgr |||||100

chadmat
The Chadinator

1974 Posts

Posted - 2013-04-29 : 17:21:08
SELECT Server, SUM(Cost)
FROM table
GROUP BY Server

-Chad
Go to Top of Page

aswindba1
Yak Posting Veteran

62 Posts

Posted - 2013-04-29 : 17:48:15
Hi Thanks for the reply..but when I am selecting the mutiple rows I am geting the follwoing error.

Msg 8120, Level 16, State 1, Line 2
Column 'Billing' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
Go to Top of Page

chadmat
The Chadinator

1974 Posts

Posted - 2013-04-29 : 17:53:52
Add the additional columns into the Group By Clause.

ie

SELECT Server, Billing, SUM(Cost)
FROM table
GROUP BY Server, Billing

-Chad
Go to Top of Page

aswindba1
Yak Posting Veteran

62 Posts

Posted - 2013-04-29 : 18:23:38
Thanks alot..its working
Go to Top of Page

chadmat
The Chadinator

1974 Posts

Posted - 2013-04-29 : 18:31:38
You are welcome.

-Chad
Go to Top of Page
   

- Advertisement -