• 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