Sequential Period generator?

[Thomson, Martyn EDUC:EX]

Hello all
Can anybody suggest a simple QTP strategy to accomplish the following - 

I have a table UWI_RANGE which contains an Id field, and start and end
periods in the format YYYYMM -char(6).

I need to populate another table UWI_PERIODS which contains the same ID
field and a PERIOD char(6) - creating one record for each month in the range
for the ID.  Currently this is done by a 'while retrieving' loop in a batch
Quick screen, but I would like to rewrite it in QTP. 

There is another table DB_PERIODS available which contains a field DB_PERIOD
char(6) and has a row for every period ever used. Perhaps this can be linked
to in some way and a SELECT statement used to limit the transaction set to
the period range?
Any help with this much appreciated.
Martyn


= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.