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
nigel.
SSChampion
Points: 11636
More actions
September 2, 2009 at 1:54 am
#1047970
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.
NigelHow to post questions