sum collumn - 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

SQL Server 2008 Forums

Transact-SQL (2008)

sum collumn

Author

Topic

papershop
Starting Member

27 Posts

Posted - 2011-08-11 : 00:49:27

Dear all

i have sintax about pivot :

select familyname, [1] as Jan ,[2] as Feb ,[3] as Mar, [4] as Apr, [5] as Mei, [6] as Jun, [7] as Jul,
as Aug, [9] as Sep, [10] as Okt, [11] as Nov, [12] as Dec
from (
select _month, familyname, valuenet from dbo.v_fact_sales
WHERE (_Year = YEAR(GETDATE())-1))up
pivot (sum(valuenet) for _month in ([1],[2],[3],[4],[5],[6],[7],,[9],[10],[11],[12]) )as pvt
order by familyname

if i want to add a column that fill sum of 3 column or(quarter)
like Quarter1 is sum of column (1 to 3) quarter2 is sum of column (4 to 6) etc

what should i add in my sintax

@papershop

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-08-11 : 00:54:11

[code]
SELECT
[1] + [2] + [3] as quarter1,
[4] + [5] + [6] as quarter2
[/code]

KH
[spoiler]Time is always against us[/spoiler]

papershop
Starting Member

27 Posts

Posted - 2011-08-11 : 01:35:48

dear KH where should i put that sintax?

@papershop

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-08-11 : 01:55:09


select familyname, [1] as Jan ,[2] as Feb ,[3] as Mar, [4] as Apr, [5] as Mei, [6] as Jun, [7] as Jul,
[ 8] as Aug, [9] as Sep, [10] as Okt, [11] as Nov, [12] as Dec,

[1] + [2] + [3] as quarter1,
[4] + [5] + [6] as quarter2

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources