Question

  Asked: Apr 26 2008   7:38 AM GMT
  Asked by: Balajisairam


IS It Possible to create Recusrive function using sql udf or stored procedures?


Recurive function, SQL UDF, VB, Visual Basic, SQL, Recursion

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

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Development and SQL Server.

Looking for relevant Development Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Balajisairam  |   Apr 28 2008  6:20AM GMT

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