USP_SIMPLEDATALIST_PROSPECTMANAGER

                CREATE procedure dbo.USP_SIMPLEDATALIST_PROSPECTMANAGER
                (
                    @PROSPECTID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select
                        PROSPECT.PROSPECTMANAGERFUNDRAISERID as VALUE,
                        NF.NAME as LABEL
                    from dbo.PROSPECT
                    cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PROSPECT.PROSPECTMANAGERFUNDRAISERID) NF
                    where
                        PROSPECT.ID = @PROSPECTID;