rx-query | Batteries included fetching library Fetch your data | Reactive Programming library

;WITH T1 AS (
    SELECT
        system.Name AS Series,
        systemElement.Name AS GroupName,
        post.Multiplicity AS 'Multiplicity',
        1 as Cnt
    FROM t_object systemElement
        INNER JOIN t_object system ON system.Object_ID = systemElement.ParentID
        INNER JOIN t_object organization ON organization.ParentID = systemElement.Object_ID
        INNER JOIN t_object post ON post.ParentID = organization.Object_ID AND post.Stereotype = 'ActualPost'
    WHERE system.Name = 'Name of my main system object'

    UNION ALL

    SELECT
        Series,
        GroupName,
        Multiplicity,
        Cnt + 1 AS Cnt
    FROM T1
    WHERE Cnt < Multiplicity
)
SELECT
    Series,
    GroupName
FROM T1
OPTION (MAXRECURSION 0) -- set recursion limit to undefined