How do I ? STORED PROCEDURE

[spDavCom]

CHALLENGE:

I have a column in a sql db that is filled with credit and debit values or + and - money values.

QUESTION:

How do I return the sum total of the positives and the sum total of the negatives from one stored procedure

NOTE:

I can do this if I write 2 stored procedures, but how do I do it in one?

Any input or syntax is much appreciated.

 

[swampBoogie]

Assuming a table named tableWithCreditDebit having a column named creditDebit.

create procedure sb_01
as
select sum(case when creditDebit < 0 then creditDebit else 0 end) as debit,
sum(case when creditDebit > 0 then creditDebit else 0 end) as credit from tableWithCreditDebit

 

[spDavCom]

Thank you! very much! Your syntax worked great!