Great Article J.

I had no idea about recursive CTE's

Thanks for pointing me in the right direction!

Thanks J!

I'm on my way to check out the article you recommended. I appreciate the reply.

..bob

Hi Bob

This is a recursive CTE, which is a supported structure in TSQL

One nice...

This is a sidebar but....

I am struggling with how the CTE is referencing itself from within itself

This works but I need clarification on it. The CTE is referencing itself...