Hi! I'm trying to develope co-operative software but having problem calculating interest in stored procedure. But i can do this from front end using vb.net. Can anyone can help me regarding this problem.My database is in microsoft sql server 2005
AccountInformation (table)
Acct_Id numeric,
Acct_Holder_Name varchar,
Acct_Type tinyint,
Interest_Type tinyint,
Acct_Open_Date
Master_Journal_Voucher(Table)
Tran_ID numeric,
Tran_Date datetime,
Jv_No numeric,
Remarks varchar
Details_Journal_Voucher(Table)
Jv_No numeric,
Particular varchar(Acct_ID),
Dr_Amt numeric,
Cr_Amt numeric,
IsInterestCalculated tinyint
Here, every account has to be compare with the AccountInformation and Detail_Journal_voucher. If there is no transactin in Details_journal_voucher then it has to skip and move to next records for further calculation.