MAXRECURSION option and CTE (Common Table Expression) – SQL Server 2005

(Paresh Prajapati) You know very well about CTE and also I wrote about the MAXRECURSION option with CTE when we have hierarchy depth level grater than 100 and due to that error is raised in previous post. So we need to define MAXRECURSION 0 option there.

Read More - Register for Free Membership