|
sgebbie
Starting Member
7 Posts |
 Posted - 2002-06-19 : 18:24:12
|
| I am really stuck with this, any help would be appreciated;I have 2 tables, Family: Father, SonValues:Son, value1, value2, value3, value4, value5I am trying to write a procedure that will perform recursion.I will supply the Sons name, then I want the function to Add 1 to value1 of his parent, add 1 to value2 of his parents parent, add 1 to value3 of his parents, parents, parent....etc up 5 levels.But there is more, some 'family trees' wont go 5 levels up so i must check for this eventuality also.eventually it should look likeson10, 0,0,0,0,0son9, 2,1,1,1,1son8, 1,2,1,1,1son7, 1,1,2,1,1son6, 1,1,1,2,1son5, 1,1,1,1,2this is way beyond anything i have tried before, so any help would be usefulthanksStephensgebbie@sglan.freeserve.co.uk |
|
help with stored procedure