Statement is terminated. The maximum recursion was exhausted before the execution of the statement was completed 100

SQL Statement recursive query member recommendation or placement relationship The times wrong: the statement was terminated. The maximum recursion has been exhausted before the execution of the statement is complete ...

The server-wide default value is 100. If you specify 0, there is no limit. You can specify only one Maxrecursion value per statement to use a similar statement:

For example:

1  Useadventureworks2008r2;2 GO3 --creates an infinite loop4  withCTE (EmployeeID, ManagerID, Title) as5 (6     SELECTEmployeeID, ManagerID, Title7      fromdbo. MyEmployees8     WHEREManagerID is  not NULL9   UNION  AllTen     SELECTCTE. EmployeeID, CTE. ManagerID, CTE. Title One      fromCTE A     JOINDbo. MyEmployees ase -          onCte. ManagerID=E.employeeid - ) the --Uses maxrecursion to limit the recursive levels to 2 - SELECTEmployeeID, ManagerID, Title -  fromCTE - OPTION(maxrecursion2); + GO

Article reference: http://bbs.csdn.net/topics/390412714

Statement is terminated. The maximum recursion was exhausted before the execution of the statement was completed 100