My stored proc takes in a node number as a parameter and returns the downline depending on the filters.

For the tree in image(attached), assuming that the RED BLOCKS have...

Hi there,

Recently my boss wanted me to experiment with this HierarchyID to see if it can improve performance of the reports that we run off of a tree with about...