+1

You all are absolutely correct. I should have specified that the code was written and tested in 2008R2, and would...

Toreador (9/19/2013)

---

I'd never have got this right if it weren't for the discussion following the other recent variable declaration question!

Interesting to know how SQLServer behaves - but hopefully such shoddy...

ChrisM@Work (9/13/2013)

---

...

Paul - if you order the output by AutoID, it all becomes clear. There's a description of how the method works here[/url]. The inventor, as far as I know,...

Indeed, not that complicated. But terribly clever!

If I'm understanding this correctly, we're lining up all of the ID and Color groups in order, and then...

I see the hitch up here...you need to see the min date and max date from each of the consecutive color/ID group pairings.

Originally, we had been treating the grouping value...

venoym (9/12/2013)

---

I might point out that your desired output is ambiguous. you have a 111/Blue group twice in your suggested output. What are your criteria for having 2...