Ineed to write hierarchyid column from LTR not default state RTL by hierarchyid datatype for example the default hierarchyid will shown as following : AccountHierarchy StringRepresentation Name /1000/1100/ 1100/1000 Current Assets I need to INSERT data inside hierarchy like StringRepresentation in table above for example 1100/1000 so that 1100 came from 1000 but in hierarchyid it must written in reverse way /1000/1100/ so please how to solve this because its hard if my tree is so big What I have tried: Reverse() function not worked it reversed 1000 to 0001
hierarchyid
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)