sp_CreateTournament - START

IF (SELECT COUNT(1) FROM vw_ActiveSeasonRefs A WHERE A.SeasonName = VarSeasonName) = 1
THEN
    IF (SELECT COUNT(1) FROM t_Sets) > 0
    THEN
        WITH RECURSIVE cte_SetIds AS
           (SELECT 1 AS SetId
             UNION ALL
            SELECT SetId + 1
              FROM cte_SetIds
             WHERE SetId + 1 < (SELECT POW(2,CEIL(LOG(2,(SELECT COUNT(1)
                                  FROM t_Signups S
                                  JOIN vw_ActiveSeasonRefs A
                                    ON S.SeasonRefFk = A.ActiveSeasonRef
                                 WHERE A.SeasonName = VarSeasonName)) - 0.5)) AS BracketSize))
        SELECT SetId + MAX(SetIdPk) AS NewSetId
          FROM cte_SetIds C
    CROSS JOIN t_Sets S;
    ELSE
        WITH RECURSIVE cte_SetIds AS
           (SELECT 1 AS SetId
             UNION ALL
            SELECT SetId + 1
              FROM cte_SetIds
             WHERE SetId + 1 < (SELECT POW(2,CEIL(LOG(2,(SELECT COUNT(1)
                                  FROM t_Signups S
                                  JOIN vw_ActiveSeasonRefs A
                                    ON S.SeasonRefFk = A.ActiveSeasonRef
                                 WHERE A.SeasonName = VarSeasonName)) - 0.5)) AS BracketSize))
        SELECT SetId AS NewSetId
          FROM cte_SetIds C;
    END IF;
ELSE
 SELECT 'Invalid Season Name';
END IF