How to Fetch The closing balance in every account number in the cursor block. [message #310478] |
Tue, 01 April 2008 07:06  |
someswar1
Messages: 53 Registered: January 2008
|
Member |
|
|
Can any one help me how I write the code in the cursor block. The problem is as follows.
The maximum date time among the combination of (ADJUSTMENTTIME, ADJUSTMENTDATE) with respect to ACCOUNTNUMBER is to be considered and the corresponding BALANCEAFTER is to be mapped to CLOSING_BALANCE.
e.g if for ACCOUNTNUMBER 918134377 the ADJUSTMENTTIME, ADJUSTMENTDATE, BALANCEAFTER is
i> 070332, 20080129, 1.123569
ii> 190356, 20080129, 2.236598
iii> 000029, 20080130, 3.569874
then CLOSING_BALANCE will be 3.569874
so how i fetch the closing balance in every account number.
Regards:
Someswar Bhattacharjee
|
|
|
|
|
|