Pls help me with this issue..
this is my query
WHERE PROCESSING_DATE between '16-May-2012' and '28-May-2012'
group by PROCESSING_DATE
order by 1
which is generating result as PROCESSING_DATE-
ACL_BALANCE_CM-653215.42 ( which s added column(TOTAL_ELECTRONIC_VALUE) with respect to date. that means if for date '16-May-2012' there are 2 entries then with this above query, it will add all the columnvalues for tat particular date from the actual table .
This is fine.,
Now my requirement s if i give PROCESSING_DATE= '17-May-2012' i need to add [ACL_BALANCE_CM] for processing date and the previous date ...(eg.'17-May-2012' ,'16-May-2012' )
Actually [ACL_BALANCE_CM] is coming from SUM(TOTAL_ELECTRONIC_VALUE-- which is the actual column name in the table)
Now again i need to add this [ACL_BALANCE_CM] for the date which i have given and its previous one
My thought s only we can achieve this with cursors only, bcoz sum(column name) means it will add all the column data, but only for some particular rows only i need to add data .. i am confused...
Please give me quick respone. (if u also suggests it can be achivable with cursor only, then i need related code, as am fully new to cursors)
Responded people are highly appreciated, thanks in advance.