Click here to Skip to main content
15,949,686 members
Search within:


How to get closing balance using stored procedure in sql server?
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
VB
Below table account trans :

TransID	TransDate	LedgerID	vid	debitamt	creditamt	vouchertype
1	05-Apr-12	3	1	0	1474	SALES INVOICE
2	05-Apr-12	4	1	0	369	SALES INVOICE
3	05-Apr-12	13	1	38703	0	SALES INVOICE
4	05-Apr-12	8	1	0	36860	SALES INVOICE
5	02-Apr-12	70	1	0	8715	PURCHASE VOUCHER
6	02-Apr-12	4	1	8715	0	PURCHASE VOUCHER
7	07-Feb-13	1	1	0	2000	QUICK PAYMENT VOUCHER


How to get closing balance using stored procedure in sql server?
Posted
Updated 8-Mar-13 6:42am
v2
Add a Solution
Comments
ZurdoDev 8-Mar-13 8:46am    
Where are you stuck? Wouldn't it just be the sum of debitamt - sum of creditamt for each day?
[no name] 8-Mar-13 9:08am    
To get the closing balance from a stored procedure, write a stored procedure that returns the balance on the account at the time the customer closed the account.
Maciej Los 8-Mar-13 14:35pm    
Please, be more specific and provide more data (example output data).

1 solution

Write the Store Proc, that returns the output paramenter. Read this parameter to read in your application.
 
Share this answer
 
Posted
Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month
Related Questions
How to convert the below query into stored procedure(MS SQL server) ?
How do i...create the trail balance with opening balance and closing balance..closing balance will become opening balance on selected date range.from two tables one is account second is transection
Store Procedure in sql server
Convert oracle procedure to SQL server procedure and give SQL server procedure?
How to use of stored procedure in SQL SERVER
SQL Server Functions And Store Procedures
Stored Procedure in Linq to Sql Server
sql server Stored Procedure (query)
Sql stored procedure not releasing from .NET
Taking the closing balance as the opening balance of the follwing month

Advertise
Privacy
Cookies
Terms of Use
Last Updated 8 Mar 2013
Layout: fixed | fluid
Copyright © CodeProject, 1999-2024
All Rights Reserved.

Web03 2.8:2024-07-22:1

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900