Mark-101232 (6/19/2013)
Here's another way using recursive CTEs
Now this is what I was hoping for. Thanks Mark! I am still trying to wrap my head around recursive CTE's and I knew there was a solution but I just couldn't see it.
Thank you very much and I appreciate the quick response.
Mike