sum multi column - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

sum multi column

Author

Topic

pamyral_279
Posting Yak Master

143 Posts

Posted - 2012-02-01 : 02:09:54

I have table :

ID---Col1---Col2---Col3--Date
1----6-------7-----4-----22/12/11
2----9-------2-----5-----4/6/11
3----3-------8----7-----19/12/11
4----4-------1----3-----15/12/11

I want output format
Col1---------Col2-----------Col3
22----------18--------------19

Please help me,
Thank you very much !

sql-programmers
Posting Yak Master

190 Posts

Posted - 2012-02-01 : 02:33:48

CREATE TABLE #T1(ID INT, COL1 INT, COL2 INT, COL3 INT,DT DATE)
GO
INSERT INTO #T1 (ID, COL1, COL2, COL3, DT)
SELECT 1,6,7,4,'2011-12-22'
UNION ALL
SELECT 2,9,2,5,'2011-04-06'
UNION ALL
SELECT 3,3,8,7,'2011-12-19'
UNION ALL
SELECT 4,4,1,3,'2011-12-15'

SELECT * FROM #T1

SELECT SUM(COL1) AS COL1,
SUM(COL2) AS COL2,
SUM(COL3) AS COL3
FROM #T1

SQL Server Programmers and Consultants
http://www.sql-programmers.com/

pamyral_279
Posting Yak Master

143 Posts

Posted - 2012-02-01 : 03:38:10

Thank you ! it help me alot !
Can you guide me to add more some of conidition ?

I want to add 'FromDay' variable and 'Today' variable mean that i only sum all values base on DT fiel in table in this 'from day' and 'today'.

Thank you again !

sql-programmers
Posting Yak Master

190 Posts

Posted - 2012-02-01 : 03:47:26

DECLARE @FROMDATE DATE = '2011-12-01'
DECLARE @TODATE DATE = '2011-12-31'

SELECT DT, SUM(COL1) AS COL1,
SUM(COL2) AS COL2,
SUM(COL3) AS COL3
FROM #T1
WHERE DT > @FROMDATE AND DT < @TODATE
GROUP BY DT

SQL Server Programmers and Consultants
http://www.sql-programmers.com/

pamyral_279
Posting Yak Master

143 Posts

Posted - 2012-02-01 : 21:38:59

Thank you :)-

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources