Hi, I have table which containse positive and negative numbers
I need sum of positive and negative numbers
create table #esal(esal int)
insert into #esal values(-2)
insert into #esal values(-3)
insert into #esal values(12)
insert into #esal values(23)
--select * from #esal
select SUM(esal) from #esal
group by case when esal>0 then '+ve' else '-ve' end
