How do I order a list with entries like x.xy.z?

Transact-SQL
12

hi

hope this helps

another trick way to do this -- "without" using hierarchy id

SELECT structure
FROM #Temp
ORDER BY (
    SELECT STRING_AGG(RIGHT('0000' + value, 4), '')
    FROM STRING_SPLIT(structure, '.')
);