UFN_PROSPECTPLAN_GETSECONDARYFUNDRAISERS

            CREATE function dbo.UFN_PROSPECTPLAN_GETSECONDARYFUNDRAISERS
            (
                @PROSPECTPLANID uniqueidentifier,
                @STATUS nvarchar(25) = null
            )
            returns table 
            as return
                select 
                    SF.ID, 
                    SF.FUNDRAISERID, 
                    NF.NAME, 
                    SF.SOLICITORROLECODEID,  
                    SRC.DESCRIPTION as SOLICITORROLECODE,
                    SF.DATEFROM,
                    SF.DATETO
                from 
                    dbo.SECONDARYFUNDRAISER as SF
                    cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(SF.FUNDRAISERID) NF
                    left join SOLICITORROLECODE as SRC on SF.SOLICITORROLECODEID = SRC.ID
                where 
                    SF.PROSPECTPLANID = @PROSPECTPLANID
                    and (@STATUS is null or SF.STATUS = @STATUS)