Hello again,

That is really impressive. Many thanks to you, Adam and Jeff Moden.

The result is missing the two Summary columns but I'll get them added.

Sorry I didn't...

Thanks for the reply. I completely forgot about ranking.

In the Dates CTE, you reference a table OHIO_REPORT_DETAILS.dbo.Tally that has a column n. What is the purpose this table?

Thanks,

Barry

Hello,

Thanks for the response. The SerNum is the widget number. Summary is actually based on three columns that gives its location. There is a one to one...

Wow, that's perfect.

Thank you