IS It Possible to create Recusrive function using sql udf or stored procedures?
Hii 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...
View Answer
| Apr 26 2008 7:38 AM GMT
| asked by
Balajisairam
Recurive function, SQL UDF, VB
help with t-sql recursion
I have a tableCREATE TABLE [dbo].[chart_hiera2]( [int] NULL, [ChildID] [int] NULL, [Child] [varchar](100) NULL, [ParentID] [int] NULL, [CGID] [int] NULL, [Depth] [smallint] NULL, [Lineage] [varchar](255) NULL, [node] [bit] NULL, [PercentOwnership] [varchar](10) NULL, [Notes] [varchar](80) NULL) ON...
Answer Question
| Mar 28 2008 8:32 PM GMT
| asked by
Ilay
Recursion, T-SQL
