Recursive CTE

Question 1

What is option(maxrecursion 0)

Answer 1

This is to specify that there is no limit on the recursion depth. By default the depth is set to 100.