| Author |
 Topic  |
|
|
ashishashish
India
3 Posts |
 Posted - 09/11/2008 : 00:38:45
|
Hii,,,i have n problem i want a store procedure in which a recursive function is present which returns the count of the records,,,,
The scenario is like this,,,,
A parent Node Has Only TWo Child Node,,,so its repeated again n again,,,so i want the count by the recursive Function,,,for that,,
help in this,,,
A
/ b c
/ \ / d e f g
n more the thing is like that,,,,,i i want the count on every node,,,or the specific node on which i wnt,,,from the recursive function ...in Sql server 2000//////// |
|
|
ashishashish
India
3 Posts |
Posted - 09/11/2008 : 01:17:16
|
Sorry...
Its Seems Like That...
So take a look n help guys,,,
Hii,,,i have n problem i want a store procedure in which a recursive function is present which returns the count of the records,,,,
The scenario is like this,,,,
A parent Node Has Only TWo Child Node,,,so its repeated again n again,,,so i want the count by the recursive Function,,,for that,,
help in this,,,
A
/ b c
/ \ /\
d e f g
n more the thing is like that,,,,,i i want the count on every node,,,or the specific node on which i wnt,,,from the recursive function ...in Sql server 2000//////// |
 |
|
|
sqlAdmin
72 Posts |
|
|
ashishashish
India
3 Posts |
Posted - 09/11/2008 : 22:59:11
|
Thanks..But my parents node allowed has maximum,,,2 child....than these two child can behave like parent node now they are allowed to have only 2 more child nodes if there is any,,,
Means....the introducer ID is repeated only two times in the data....
and not more than two time...so i have to sat a relation between this,,,,
Thanks,,,,,, |
|
|
| |
Topic |
|
|
|
Want help In Recursive Function to Count,,,,
