Thanks for responding. I actually did try using joins as my first choice, but the results were incorrect:

PntKey Qty FromDate1 ToDate1 FromDate2 ToDate2

----------- ----------- ---------- ---------- ---------- ----------

1 100 2012-01-01 2012-02-01 2011-12-01 2011-12-31

1 100 2012-04-01 2012-05-01 2011-12-01 2011-12-31

2 200 2012-01-15 2012-05-15 2012-01-01 2012-02-01

2 200 2012-01-15 2012-05-15 2012-02-15 2012-05-15

3 300 2012-05-01 2012-07-01 2012-09-01 2012-10-01

(5 row(s) affected)

For PntKey 1 the FromDate2 and ToDate2 are duplicated and for PntKey 2 the FromDate1 and ToDate1 are duplicated, but I only want them to appear once. Also, the Qty gets duplicated, which will overstate it. It seems like it shouldn't be this much of a challenge but I've been struggling to come up with something that works.