I believe you are referring to MAXRECURSION hint It is used in recursive Common table expressions. You can get more about it in http://msdn.microsoft.com/en-us/library/ms181714(SQL.90).aspx
[quote user="RVG"] Hi, Just wanted to know what is meant by max recursion function. Thanks & Regards, Ravi Varma. [/quote] It is used to terminate the recursion of the CTE OPTION (MAXRECURSION 20) means "Do the recursion for 20 times"
As you got the reply, I would like to remind you about Books Online which can be used as first hand help and more information can be obtained (don't get me wrong) [].
