Had very similar problem. We have a workflow app where tasks can have several layers of child tasks. Child rows have a reference to the parent id. Had to write code (delete trigger) which created a temp table to collect all the ids for the child rows. Then scaned throught the temp table and deleted each one ending with the delete of the parent.