Hello all,
If you have read my article about Recursive CTE Split function
MS SQL Server Recursive T-SQL Split Function and if you have used it with a large number of concatenated values waiting to be seperated, you might have get the following error message :
The statement terminated. The maximum recursion 100 has been exhausted before statement completion.
This is because by default CTE (Common Table Expression) functions are preconfigured for a maximum recursive number of 100. (MAXRECURSION )
So you can easily configure this maximum recursion number MAXRECURSION from 100 to 32767 which is maximum value which can be defined except setting the value of MAXRECURSION to 0 which causes no limit to be applied on the recursive CTE function
You can easily overcome this maxrecursion problem by adding the "OPTION ( MAXRECURSION 0 )" query hint to the end of the recursive select statement as I have updated the function at my
MS SQL Server Recursive T-SQL Split Function article.