• are you doing something that a Recursive CTE could resolve?

    http://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/