I need to create an HR anizational hierarchy for positions in company. I have the below data:

enter image description here

and in the end the data should look like this:

enter image description here

any ideas?

Thanks,

M

I tried with recursive CTE, but I cannot propagate the values until the last level of hierarchy.