I have a table with the following columns
this table is used to create a tree structure of any level deep. Now I want to create a procedure/function that gets the node id as a parameter and deletes all its children till the end. Under the passed node id there can be any level of nodes...sub nodes ...etc.
can anyone please point me to an article or procedure/function that does this.
Thanks in advance