I am new to stored procedures. As part of our application, we have a database with one of the tables having child-parent relationships. Given an id, we should be able to figure out the final parent of the id, traversing through the child-parent links in the table.
Input1: 10943, Output1: 8656
Input2: 5005, Output2: 9151, 9160
Different possibilities
An id could have multiple final parents, An id may not have a parent
Any inputs would be appreciated. Thanks in advance.