I've used Hierarchyid data type in one of my tables in SQL Server.
Now I want to change the father of one of the rows, but when I change that all its descendant HierarchyId's must change according to that.
Is there a function to do that or I must change all of them myself. If I need to do that, what is the best way ?
Thanks In advance