Click here to Skip to main content
14,639,057 members
Rate this:
Please Sign up or sign in to vote.
See more:
In loan pending emi should be automated..
For that i need code..
I tried some code but it is not working....
And also i want to use that calculation in DAL and want to execute...
So please atleast let me know the general calculation or logic to implement..
Reply as soon as possible...
Thank u.....
Posted
Comments
Prasad_Kulkarni 13-Mar-12 2:18am
   
post your code..
Charuroopa 13-Mar-12 3:00am
   
I Have created using DAL this is the query wat i created..
INSERT [table] EXECUTE ('SELECT e.emp_id,
(CASE WHEN l.emis_pending > 0 THEN l.loan_id else 0 end) as loan_id,
@date,
(CASE WHEN l.emis_pending > 0 THEN (l.principal_amt/l.tot_emis) else 0 end) as emi_amt
FROM earning e, loan l
WHERE (e.emp_id = lm.emp_id) AND (lm.emis_pending > 0)')
This is for inserting in loan transaction..
And for emi pending i just created this much:
SELECT *
FROM table
WHERE emp_id = @emp_id AND emis_pending > 0
i dont know how to proceed further....

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100