Hi guy,
Im have couple of question here.
First..
For Example:
Customer_ID, Credit_Left , Date To, Date From
C123, 100, 1/6/2011, 2/6/2011
C123, 80, 2/6/2011,11/6/2011
C123, 120, 11/6/2011, 31/12/2011
How do i get the following output result Eg
C123,100,1/6/2011
C123,80,2/6/2011
C123,80,3/6/2011
C123,80,4/6/2011
...........
C123, 120 11/6/2011
C123, 120 12/6/2011
C123,120, 12/6/2011
.......
C123,120 31/6/2011
Second..Izzit possible to store all the looping result into existing database without record duplicate?
The output result i wish to get which is the last day of the month and sum all the Amount from different customer for doing report.
P:S I got existing table with many attribute also. im just taking out some field for doing report,
Please help me out
Thank You
Regard
Matt
