fnGetTeamIsPartOfTeam

CREATE function dbo.fnGetTeamIsPartOfTeam(@TeamID int, @ParentTeamID int)
returns bit
as
begin
    if @TeamID is null return 0

    declare @ReportsToID int
    declare @Result bit

    set @Result = 0

    select @ReportsToID = ReportsToID
    from FundraiserTeams
    where ID = @TeamID

    if @@rowcount = 1
    begin
        if @ReportsToID is null
            set @Result = 0
        else
            if @ReportsToID > 0 
                if @ReportsToID = @ParentTeamID
                    set @Result = 1
                else
                    set @Result = dbo.fnGetTeamIsPartOfTeam(@ReportsToID, @ParentTeamID)
        end                   
    return @Result
end