I played some more with this and got the necesary data to be able to process the data and get the structure:
With hierarchy (Link_ID,ID,TopLevel,level, Description, Sort,Ord) AS
(
Select
Link_ID,
ID,
ID As Toplevel,
0,
Description,
cast(Description...