UFN_PROSPECTMANAGERHISTORY_VALIDENDDATE_2

            create function dbo.UFN_PROSPECTMANAGERHISTORY_VALIDENDDATE_2
                (
                @PROSPECTID uniqueidentifier,
                @FUNDRAISERID uniqueidentifier,
                @DATETO datetime
            )
            returns bit
            with execute as caller
            as begin

                if exists (
                    select top 1
                        ID
                    from
                        dbo.PROSPECT
                    where
                        @PROSPECTID = ID and
                        @FUNDRAISERID <> PROSPECTMANAGERFUNDRAISERID AND 
                        (
                            (
                                (PROSPECTMANAGERSTARTDATE is not null) and
                                (PROSPECTMANAGERSTARTDATE < @DATETO)
                            ) or
                            (
                                (PROSPECTMANAGERENDDATE is not null) and
                                (PROSPECTMANAGERENDDATE < @DATETO)
                            )
                        )
                    )
                    return 0;

                return 1;

            end