Hi adelinetfl.smkss
You can increase the number to something greater than 100. Not advocating anything here 🙂
See Query Hints in SQL Server Books online:
...MAXRECURSION number
Specifies the maximum number of recursions allowed for this query. number is a non-negative integer between 0 and 32767. When 0 is specified, no limit is applied. If this option is not specified, the default limit for the server is 100....
...One of the symptoms of an approaching nervous breakdown is the belief that ones work is terribly important.... Bertrand Russell