The maximum recursion 100 has been exhausted before statement completion

by

Specify the maxrecursion option at the end of the query:

...
from EmployeeTree
option (maxrecursion 0)

That allows you to specify how often the CTE can recurse before generating an error. Maxrecursion 0 allows infinite recursion.

More Related Contents:

  1. Paging with Oracle
  2. Can I pass column name as input parameter in SQL stored Procedure
  3. SQL Server Insert if not exists
  4. Pass multiple values in single parameter
  5. Difference between CTE and SubQuery?
  6. Update records in table from CTE
  7. When to use Common Table Expression (CTE)
  8. Search text in stored procedure in SQL Server
  9. How do I execute a stored procedure once for each row returned by query?
  10. Return multiple fields as a record in PostgreSQL with PL/pgSQL
  11. Multiple CTE in single query
  12. Dynamic Sorting within SQL Stored Procedures
  13. Call a stored procedure with another in Oracle
  14. SQL: Select dynamic column name based on variable
  15. Which is better: Ad hoc queries or stored procedures? [closed]
  16. Execute Immediate within a stored procedure keeps giving insufficient priviliges error
  17. Delete parent if it’s not referenced by any other child
  18. Procedure or function !!! has too many arguments specified
  19. Is it possible to have a default parameter for a mysql stored procedure?
  20. Solution to “cannot perform a DML operation inside a query”?
  21. Custom Date/Time formatting in SQL Server
  22. Inserting rows into a table with one IDENTITY column only [duplicate]
  23. How to get rid of “Error 1329: No data – zero rows fetched, selected, or processed”
  24. Eliminate and reduce overlapping date ranges
  25. What is the difference between a stored procedure and a view?
  26. Functions vs Stored Procedures
  27. How to execute a stored procedure inside a select query
  28. Use one CTE many times
  29. Call stored procedure with table-valued parameter from java
  30. Insert into from CTE

Leave a Comment