SQL Server User-Defined Tree Functions

• Get Tree Node Level Function

  ---

  Returns the level of a given node in a hierarchical/tree-type table.

• Get Tree Path Function

  ---

  Returns the path of a node from the parent to the current node in a hierarchical/tree-type table.