It doesn't do what I supposed it would do. > A column of type hierarchyid does not automatically represent a tree. It is up to the application to generate and

It doesn't do what I supposed it would do. > A column of type hierarchyid does not automatically represent a tree. It is up to the application to generate and assign hierarchyid values in such a way that the desired relationship between rows is reflected in the values. Some applications might have a column of type hierarchyid that indicates the location in a hierarchy defined in another table.