fnGetFundRaiserIDForSolicitor

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

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

    set @Result = null

    select    @FundRaiserID = FundRaiserID, 
            @TeamID = TeamID, 
            @ReportsToID = ReportsToID
    from FundraiserSolicitors
    where ID = @SolicitorID

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