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)
are you doing something that a Recursive CTE could resolve?http://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/