I have a fellow that's trying to resolve some performance issues in a HierarchyID-based table. I just don't use HierarchyID because I've found or made better ways to work with hierarchies and so I need some help, please.
Several years ago, I ran into an article somewhere that demonstrated how to cnvert a HierarchyID-based hierarchr back to adjacency list but I can't find that article nor any article on Google, Dusk-Duck-Go, or BING that even comes close.
With that, do any of you good folks know how to do such a thing? I think I might be able to help this person if we can do that. Here's the link to the pertinent part of the thread of the person I'm trying to help.
Thank you for reading this whether you can help or not.