Shannon.Inge
Member
In order to do some reporting outside of E1, I need to find the top parent for any given child in F0150. The hierarchies vary in the number of levels and the child entered may not be the bottom child. How can I accomplish this in a SQL query?
I'm hoping someone has done this before and I won't have to reinvent the wheel, but if I figure it out before I get an answer I'll be sure to post it for future reference.
I'm hoping someone has done this before and I won't have to reinvent the wheel, but if I figure it out before I get an answer I'll be sure to post it for future reference.