sp_AddSignup

IF (SELECT COUNT(1)
      FROM vw_ActiveSeasonRefs A
     WHERE A.SeasonName = VarSeasonName) = 1
THEN
    IF VarSignup <> ''
    THEN
        IF (SELECT COUNT(1) FROM t_Players WHERE Player = VarSignup) = 0
        THEN
            INSERT INTO t_Players (Player) VALUES (VarSignup);
        END IF;

        INSERT INTO t_Signups (SeasonRefFk, PlayerIdFk, SignupOrder)
        SELECT A.ActiveSeasonRef AS SeasonRefFk,
               PlayerIdPk AS PlayerIdFk,
               IFNULL(MAX(SignupOrder),0) + 1
          FROM vw_ActiveSeasonRefs A
         CROSS JOIN t_Players P
          LEFT JOIN t_Signups S
            ON S.SeasonRefFk = A.ActiveSeasonRef
         WHERE A.SeasonName = VarSeasonName
           AND P.Player = VarSignup;
     ELSE
         SELECT 'No signup found.';
     END IF;
ELSE
    SELECT 'Invalid season name.';
END IF