Hi,
Is there any way to use recursion in stored procedure, i.e. I want to use stored procedure recursively. How to do this ?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Pravin MorePosted Dec 28, 2011, 12:00 AM
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 LingePosted Dec 27, 2011, 11:31 PM
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 NayakPosted Dec 27, 2011, 11:28 PM
Please refer the below link
http://www.techrepublic.com/article/using-recursion-in-stored-procedures/5700193
Thanks