I was running a CTE an got the following Error message:
'The statement terminated. The maximum recursion 100 has been exhausted before statement completion.'
The statement would undertake over 100 recursions hence the message. To rectify, I added the following query hint:
OPTION (MAXRECURSION 500);
Overriding the default of 100 for this particular statement.