Hi Jeff,

How do I modify the code you provided to now include the first and last month of the consecutive service?

Hi Jeff,

Thank you SO both fixing up my code and providing the solution. I tested and it works wonderfully!

Thanks again 😀

I was able to get this to work. The sample records I gave you above were a subset of fields from the original table. I created a new...

Thanks Luis.

I tried your code on my sample data and it produced 0 output records.

Thanks,, I already tried rownumber over partion and that didn't work. The notes comments was just for clarification of what I need to capture, and is not present in...