fnGetSolicitorIsPartOfTeam

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

    declare @ReportsToID int
    declare @TeamID int
    declare @Result bit

    set @Result = 0

    select @ReportsToID = Team.ReportsToID, @TeamID = Solicitor.TeamID
    from FundraiserTeams Team
    inner join FundRaiserSolicitors Solicitor on Solicitor.TeamID = Team.ID
    where Solicitor.ID = @SolicitorID

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