Your code returns 1 group with 2001-01-05 as the min begin and 2001-01-11 as the max end. I need groups of consecutive dates only as in my example.

Thanks for the reply.

John

>

>SELECT Consumer, Provider, Service, Min(Begin) AS MinOfBegin, Max(End) AS MaxOfEnd
>FROM MyTable
>GROUP BY Consumer, Provider, Service;
>