Home Forums SQL Server 2005 T-SQL (SS2K5) The maximum recursion 100 has been exhausted before statement completion RE: The maximum recursion 100 has been exhausted before statement completion

  • Sure, setting MAXRECUSRION will work, but at what expense?

    Grant even said in his post that it wasn't the greatest approach.

    I would avoid recursive CTEs if there is a more efficient solution, which in this case there is.