Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravininave
Posting Yak Master
111 Posts |
 Posted - 2010-02-19 : 04:33:54
|
| Hi All,In my application user enters a data of Customer who has to pay their amount in installments for that I've created two tables 1] InsMast - Holds Information about Installments which has to be received. Generates all Ins from Customer Entry. 2]Receipts - Whenever Customer pays amount goes to receipts.Table StructureINSMAST : AppCode,InsDate,InsAmtRECEIPTS : AppCode,vDate,vAmountNow I've to find those Customer Who hadn't paid since from last 2 or 3 months. How Could I? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-19 : 06:12:37
|
| so does INSMAST have details of each installments to be payed by each customers? Does InsDate represent last date of payment?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
ravininave
Posting Yak Master
111 Posts |
Posted - 2010-02-21 : 09:07:15
|
Yes, INSMAST have details of each installment all the pay dates of each customer.quote:
Originally posted by visakh16
so does INSMAST have details of each installments to be payed by each customers? Does InsDate represent last date of payment?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-21 : 09:16:17
|
| so we need to compare receipts against INSMAST and check if date is within 2 or 3 months period?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Defaulter List Query