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.

Max