SQL Top parent record in hierarchy

https://stackoverflow.com/questions/9211173/sql-top-parent-record-in-hierarchy