regarding the original query. It seems repetition of the characters is not allowed. This is therefore not a permutations calculator but is a combinations calculator.

after playing with hierarchyid and mainly it's GetReparentedValue feature i have to say I am disappointed.

As well as the problem mentioned above by kent.kester I found that using GetReparentedValue to...