Jeff would it be easy to modify your code if the

Desired Result was:

Key Product from_date to_date

1 A 2010-01-01 2010-01-01 --different end date

1 A 2010-01-02 2010-01-03 --This is a new record...