I have a table which contains Purchase Order data, which I would like to split into multiple records in another table.

For example, one Purchase order has a value of 12,000, a quantity of 12 and a start and end date of 1/1/13 & 31/12/13 respectively. (Quantity obviously being number of months).

So what I would like to do, is take this record and create a payment schedule table with a separate record for each
month - so create 12 rows showing Jan, Feb, Mar etc etc with a value of 1000 per month.

I will then be able to join to invoice table to track payment for each month.

I have found this old thread

which creates a string showing months and value but doesn't really help me achieve above.

Any assistance would be most appreciated.