Thank you Mark, perfect !!

i generate the "data" i need like this

;WITH data AS

(

SELECT descendants.id as id, descendants.name AS childname, ancestors.id as parentid, ancestors.name as parentname FROM TreePaths paths

...

Hello Mark,

i was browsing the forum for similar questions and indeed found an old thread where you adviced the same.

do you think i can use this solution with a...