fnGetFundRaiserIDForTeam

create function dbo.fnGetFundRaiserIDForTeam(@TeamID int)
returns int
as
begin
    if @TeamID is null return 0

    declare @FundRaiserID int
    declare @ReportsToID int
    declare @Result int

    set @Result = null

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

    if @@rowcount = 1
    begin
        if @FundRaiserID is not null
            set @Result = @FundRaiserID
        else
            if @ReportsToID > 0 
                set @Result = dbo.fnGetFundRaiserIDForTeam(@ReportsToID)
        end                   
    return @Result
end