UFN_PROSPECTPLAN_CURRENTSECONDARYFUNDRAISERS

            CREATE function dbo.UFN_PROSPECTPLAN_CURRENTSECONDARYFUNDRAISERS
            (
                @PROSPECTPLANID uniqueidentifier
            )
            returns table 
            as return
                select 
                    SF.ID, 
                    SF.FUNDRAISERID, 
                    SF.SOLICITORROLECODEID, 
                    SF.SEQUENCE, 
                    NF_C.NAME, 
                    SRC.DESCRIPTION as SOLICITORROLECODE,
                    SF.DATEFROM,
                    SF.DATETO
                from 
                    dbo.SECONDARYFUNDRAISER as SF
                    left join SOLICITORROLECODE as SRC on SF.SOLICITORROLECODEID = SRC.ID
                    cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(SF.FUNDRAISERID) NF_C
                where 
                    SF.PROSPECTPLANID = @PROSPECTPLANID and
                    STATUS <> 'Prior'