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
April 26, 2008 7:38 AM
April 28, 2008 12:53 PM