Firstly, Thank you all for you help in solving this problem. I have some great idea's that I can use CTE's for on my other 2005 SQL DB's.

Ken,

The code...

Thank you for your posts and helpful information. From my reading on CTE's, I believe I will not be able to use a CTE as we a running this...