SELECT OS.NAME
    ,OS.ITEMID
    ,OS.PARENTID
    ,PARENTNAME = (
        SELECT NAME
        FROM OPERATIONALSTRUCTURE AS OS2
        WHERE OS.PARENTID = OS2.ITEMID
     )
    ,OS.HIERID
    ,HIERNAME = (
        SELECT NAME
        FROM OPERATIONALSTRUCTURE AS OS3
        WHERE OS.HIERID = OS3.ITEMID
            AND H.HIERID = OS3.HIERID
     )
    ,OS.HIERLEVEL
    ,H.LEVELNAME
FROM OPERATIONALSTRUCTURE AS OS
INNER JOIN HIERLEVELS H
    ON H.HIERLEVEL = OS.HIERLEVEL
ORDER BY OS.HIERID
    ,OS.PARENTID
    ,OS.NAME

SELECT OS.NAME
    ,OS.ITEMID
    ,OS.PARENTID
    ,PARENTNAME
    ,OS.HIERID
    ,HIERNAME 
    ,OS.HIERLEVEL
    ,H.LEVELNAME
FROM OPERATIONALSTRUCTURE AS OS
INNER JOIN HIERLEVELS H
    ON H.HIERLEVEL = OS.HIERLEVEL
CROSS APPLY (
    SELECT NAME AS PARENTNAME
    FROM OPERATIONALSTRUCTURE AS OS2
    WHERE OS.PARENTID = OS2.ITEMID
) AS OS2
CROSS APPLY (
    SELECT NAME AS HIERNAME
    FROM OPERATIONALSTRUCTURE AS OS3
    WHERE OS.HIERID = OS3.ITEMID
        AND H.HIERID = OS3.HIERID
) AS OS3
ORDER BY OS.HIERID
    ,OS.PARENTID
    ,OS.NAME