FIGURE 2 Ranges of activity—SQL Server 2000, step 1
storeid	dt	grp
-------	----------	----------
1	2005-01-01	2005-01-03
1	2005-01-02	2005-01-03
1	2005-01-03	2005-01-03
1	2005-01-23	2005-01-26
1	2005-01-24	2005-01-26
1	2005-01-25	2005-01-26
1	2005-01-26	2005-01-26
2	2005-01-05	2005-01-06
2	2005-01-06	2005-01-06
2	2005-01-10	2005-01-10
2	2005-01-28	2005-01-31
2	2005-01-29	2005-01-31
2	2005-01-30	2005-01-31
2	2005-01-31	2005-01-31