SELECT PaymentTracker1.* ,DATEADD(m,N,StartDate) AS DueDate , CASE WHEN GETDATE() > StartDate THEN (Numbers.N - DATEDIFF(m,StartDate,GETDATE())) * MonthlyPay ELSE Numbers.N * MonthlyPay END AS DueAmount FROM PaymentTracker1 INNER JOIN Numbers on DATEDIFF(m,PaymentTracker1.StartDate,PaymentTracker1.EndDate) >= Numbers.N where DueDate is current date ORDER BY PaymentTracker1.Name ,Numbers.N
where datepart(m,DueDate)= datepart(m,getdate()) AND datepart(yy,DueDate)= datepart(yy,getdate())
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)