Recursion

Question

Hi Is there any way to use recursion in stored procedure i.e. I want to use stored procedure recursively. How to do this ?

Pravin More · Answer

Hello Manoj you can use Recursive CTE for it. Recursive is the process in which the query executes itself. It is used to get results based on the output of base query. We can use CTE as Recursive CTE (Common Table Expression). Click Here for simple example. Thanks Pravin.

Priya Linge · Answer

Hi Please check below link. http://www.informit.com/articles/article.aspx?p=25288&seqNum=13 http://www.techrepublic.com/article/using-recursion-in-stored-procedures/5700193 Hope this will help you. Thanks.

Satyapriya Nayak · Answer

Hi Manoj Please refer the below link http://www.techrepublic.com/article/using-recursion-in-stored-procedures/5700193 Thanks