Lutz, i will try to follow your steps in details tomorrow...
Jeff, i don't need an EndDate and rather than a total NumberOfPeriods i would need to see the period details (i.e. RentalDate):
at present i have 1 line (ContractNumber,StartDate,RentaAmount,RetalFrequency)
i need to get to the 7 lines in my example above (ContractNumber, RentalDate, RentalAmount)
for each ContractNumber i always know the StartDate and need to recreate each RentalDate between StartDate and GetDate() based on RentalFrequency.
so the example above would output 7 records, i.e. 7 quarters between StartDate and GetDate()
if the RentalFrequency was 'monthly' then the query should have returned 20 records, i.e. 20 monthly payment from StartDate '01/01/2013' to GetDate() '03/08/2014'
thanks guys
paul