UFN_PROSPECT_MANAGERS

            CREATE function dbo.UFN_PROSPECT_MANAGERS(@PROSPECTID uniqueidentifier) 
            returns nvarchar(400)
            with execute as caller
            as begin
                declare @CURRENTDATEEARLIESTTIME datetime;
                set @CURRENTDATEEARLIESTTIME = dbo.UFN_DATE_GETEARLIESTTIME(getdate());

                declare @LIST nvarchar(400)
                set @LIST = ''
                declare @CC nvarchar(100)
                declare CUR cursor local fast_forward for 
                    select
                        NF.NAME
                    from
                        dbo.PROSPECTPLAN PP
                        inner join dbo.PROSPECTPLANTYPECODE STC on STC.ID=PP.PROSPECTPLANTYPECODEID
                        cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PP.PRIMARYMANAGERFUNDRAISERID) NF
                    where
                        PROSPECTID=@PROSPECTID and  
                                (
                                    PP.PRIMARYMANAGERENDDATE is null or
                                    PP.PRIMARYMANAGERENDDATE >= @CURRENTDATEEARLIESTTIME
                                )
                    order by
                        STC.SEQUENCE
                open CUR
                fetch next from CUR into @CC
                while @@fetch_status = 0 begin
                    if len(@LIST) > 0
                        set @LIST = @LIST + ', '
                    set @LIST = @LIST + @CC
                    fetch next from CUR into @CC
                end
                close CUR
                deallocate CUR
                return @LIST
            end