> SP recursively because you can only nest 32 calls deep T-SQL only gives you 100 calls deep. Also, having CTEs calling other CTEs can create a very slow query

> SP recursively because you can only nest 32 calls deep T-SQL only gives you 100 calls deep. Also, having CTEs calling other CTEs can create a very slow query plan, which takes unrolling each CTE into either a table variable or temp table to resolve.