Unanswered: Splitting into months / creating new record
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.