fnUserIsOnTeams

CREATE FUNCTION dbo.fnUserIsOnTeams (@EEID INT, @Season UNIQUEIDENTIFIER)
RETURNS BIT
AS
BEGIN
    DECLARE @Teams TABLE (
        ID INT
    )

    --Player's Teams

    INSERT INTO @Teams
    SELECT ar.TeamID
    FROM dbo.ATHLETICS_ROSTERS ar
        INNER JOIN dbo.ATHLETICS_TEAMS at
            ON ar.TeamID = at.ID
    WHERE ar.PlayerEEID = @EEID
        AND at.Season = @Season

    --Coach's Teams

    INSERT INTO @Teams
    SELECT ac.TeamID
    FROM dbo.ATHLETICS_EECOACHES ac
        INNER JOIN dbo.ATHLETICS_TEAMS at
            ON ac.TeamID = at.ID
    WHERE ac.CoachEEID = @EEID
        AND at.Season = @Season

    RETURN (CASE
                WHEN (SELECT COUNT(*) FROM @Teams) > 0
                    THEN 1
                ELSE
                    0
            END)
END