Hi...This question might be easy for some of you out there, but i am having a difficult problem with it. I have a tree structure with the parent node being the "propertyID" and the leaf nodes are the "propertyType" associated with the propertyID.
How can i create a Store Procedure that would prints a list of leaf nodes given the propertyID? Also, how can i create a trigger that would delete a sub-tree below a node, and back up that sub-tree including the node where it trigger the deletion, onto a back_up table?
Very challenging...can someone help or good hints???