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 2000 Forums
 SQL Server Development (2000)
 How to make a stored procedure with computations

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-28 : 10:03:55
Liezel writes "How do I make a stored procedure that computes for the depositor's beginning actual and cleared balances.

To make this clear, say I have a table that stores all the transactions made by the depositor (e.g. deposits, withdrawals,etc.). Now, I need to generate a report showing all depositors' balances as of a given date. I need to pass the date to the stored procedure and the stored procedure reads the table containing all the depositors' transactions and compute for the balances. The beginning actual and cleared balances will then be returned by the procedure.

Please help me ASAP. THANKS..."

JustinBigelow
SQL Gigolo

1157 Posts

Posted - 2002-06-28 : 10:27:00
You'll need to provide your table layout (ddl) for us to be able to help you.

Justin

Go to Top of Page
   

- Advertisement -