Home > IT Answers > SQL Server > IS It Possible to create Recusrive function using sql udf or stored procedures?
Balajisairam
15 pts.
 IS It Possible to create Recusrive function using sql udf or stored procedures?
Recurive function, Recursion, SQL, SQL UDF, VB, Visual Basic
Hi i have a scenario of n level tree structure.in order to traverse to my desired node i am using Recursive function until i get my desired node in my vb code but i am getting a performance issue. SO i reckon that this performance can be overcome by using sql udf or stored procedure. If so please help me coz i am pondering over this concept Thanks in advance

Software/Hardware used:
ASKED: April 26, 2008  7:38 AM
UPDATED: April 28, 2008  12:53 PM
RELATED QUESTIONS
Answer Wiki:
Recursive functions are possible, but usually not recommended because of the performance hit. What platform and version are you using? That will determine what options are available to you.
Last Wiki Answer Submitted:  April 27, 2008  8:13 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Thanks for The reply Mr.Denny.
Well i am using .net platform 2.0 and sql server 2005
i was too getting the same performance issue when i use this in my vb code.
But if i use recursion i am getting the exact answer.
Is there any other possibility to overcome this issue.
Thanks
Regards
Balaji

Balajisairam
 15 pts.