Click here to Skip to main content
14,766,632 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi, i have one table name Ageing and there are many rows like CustCode,Date,BillPayment,ReceiptPayment,Due and i want to show all records like this formet
CustomerCode,BillPayment,ReceiptPayment, <30Days,30-60Days,60-90Days,90-180Days,Due...
Posted
Comments
[no name] 5-Dec-11 4:48am
   
can you give us your desired output?
Member 8357723 5-Dec-11 5:07am
   
CustomerCode Date ReceiptPayment BillPayment Due
ARKNMI 22/9/2010 19800 477 19323
ARKNMI 22/9/2010 19323 21 19302
ARKNMI 18/10/2010 19302 1204 18098
ARKNMI 17/11/2010 18098 473 17625
ARKNMI 18/11/2010 17625 385 17240
ARKNMI 17/1/2011 17240 959 16281
ARKNMI 17/2/2011 16281 510 15771
ARKNMI 25/3/2011 15771 163 15608
ARKNMI 28/3/2011 15608 1239 14369
ARKNMI 15/4/2011 14369 1926 12443
ARKNMI 26/6/2011 12443 932 11511
ARKNMI 4/8/2011 11511 457 11054
ARKNMI 10/8/2011 11054 721.35 10332.65
ARKNMI 15/09/2011 10332.65 103.05 10229.6
ARKNMI 26/10/2011 10229.6 824.4 9405.2
ARKNMI 15/11/2011 9405.2 9227.15 178.05
ARKNMI 20/11/2011 178.05 1563.27 -1385.22
ARKNMI 25/11/2011 -1385.22 571.93 -1957.15
ARKNMI 30/11/2011 -1957.15 1406.64 -3363.79

1 solution

   
Comments
Amir Mahfoozi 5-Dec-11 6:59am
   
+5'ed :)

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




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900