tag:blogger.com,1999:blog-495177919198719500.post2159752897200992645..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: SQL Server Stored Procedure Recursion LimitSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-495177919198719500.post-85688489181463996382017-06-05T20:12:32.562-07:002017-06-05T20:12:32.562-07:00Can you give an example of a good use case for thi...Can you give an example of a good use case for this approach?Bearhttps://www.blogger.com/profile/06405749718258946705noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-56741053191467151732017-04-04T05:09:13.625-07:002017-04-04T05:09:13.625-07:00please can you give proper reason... why limit is ...please can you give proper reason... why limit is 32 for recursion?Prajakta Salokhehttps://www.blogger.com/profile/04903886742046412589noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-88632752950901132472015-03-25T07:45:33.985-07:002015-03-25T07:45:33.985-07:00@ax4413 Yes I meant the default limit is 100. Than...@ax4413 Yes I meant the default limit is 100. Thanks for the info about MAXRECURSION.Suprotim Agarwalhttps://www.blogger.com/profile/08349831623922214390noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-48816951807442898922015-03-25T03:54:32.946-07:002015-03-25T03:54:32.946-07:00There is no recursion limit when using cte's. ...There is no recursion limit when using cte's. there is a default limit that can be extended by using the MAXRECURSION hint to 32,767. However if you set the MAXRECURSION to zero there is no recursive limit. Be careful though as there is a default limit for a reason.ax4413https://www.blogger.com/profile/02292654440388485624noreply@blogger.com