Conditional Sum in SQL Query

[Tufail Ahmad]

I use SQL Server 2005. Case is Valsue in Totall field are: -2, 5,4,-1 Select sum(Total) as sTotal from Table1. it gives 6. i want to sum positive and negative values seperatly that is Select sum(Total) as PositiveSum, Sum(total) as NegetiveSum as sTotal from Table1.

[Pranay Rana]

use case when statement like sum(case when colvalue<0 then colvalue end) as [Total negative], sum(case when colvalue>=0 then colvalue end) as [Total positive],

[Mycroft Holmes]

Use a case statement

Sum(Case when ValueField > 0 then ValueField else 0 end) SumPositive,
Sum(Case when ValueField < 0 then ValueField else 0 end)

Never underestimate the power of human stupidity RAH

[Niladri_Biswas]

Even you can try this declare @t table(field int) insert into @t select -2 union all select 5 union all select 4 union all select -1

select top 1
PositiveSum = (select SUM(field) from @t where field >0)
,NegetiveSum =(select SUM(field) from @t where field <0)
from @t

Output:

PositiveSum NegetiveSum
9 -3

:)

Niladri Biswas