Recursion in Stored Procedures 1

[cgiles]

I am looking for a script that will &quot;walk&quot; a tree structure in one table.&nbsp;&nbsp;<br><br>Specifically I am working with pstreenode table in peoplesoft where an identifier column (x) in a row equates to an identifier column in another row.&nbsp;&nbsp;If you follow this tree stucture &quot;up&quot; the table you get a hierarchal sturcture (ie department rollup).

 

[Guest_imported]

Hi cgiles<br>&nbsp;If I understood correctly It can be done without recursion also. Just see the respone I wrote for &quot;directory&quot;. It's for exploring one department. Add one outer while loop to expore the complete tree.<br>&nbsp;If you need some more info pleae feel<br>Bye<br>Shekar<br>&nbsp;<br>