I have this case in teradata, where in the certain set of child members (which are eventually parent members later) should be eliminated (along with their level 0 members ) and rest of the members alone should be fetched.
and so on.
If i omit the member '100' all the members under that should also be eliminated.
is recursive function helpful to solve this ? Please help.