Thank you for your post.  That is really close...

results as follows:

123                    1          1 20050401 20050410

123                    1          1 20050415 20050422

123                    1          1 20050424 20050430

123                    1          1 20050418 20050428

4                      4          4 20040101 20040108

4                      4          4 20040106 20040114

However, member 123, has a span 20050415 to...

Wow nice.  Thank you for the reply.

That is definately on the right track.  I am sorry, I think I was a little mis-leading when I said the resulting records need to be...