CTE wouldnt work because I am joining the table to itself meaning the field names would be the same and SQL doesnot accept that.
davidandrews13 (3/20/2013)
http://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/%5B/quote%5D