I'm trying to create an SQL Stored Procedure to do the following...
I have a table with
2) debit/credit indicator
and my procedure should get the "total_balance" by subtracting "total_credit" from "total_debit"
does any one knows how to accomplish this?
Note:- I'll also use this procedure on crystal report.