UFN_PROSPECTPLANMANAGERHISTORY_VALIDCONSTITUENT

Validates the start and end dates of a primary/secondary manager on a prospect plan.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@PROSPECTPLANMANAGERHISTORYID	uniqueidentifier	IN
@PROSPECTPLANID	uniqueidentifier	IN
@ISPRIMARYMANAGER	bit	IN
@DATEFROM	datetime	IN
@DATETO	datetime	IN

Definition

Copy



            CREATE function dbo.UFN_PROSPECTPLANMANAGERHISTORY_VALIDCONSTITUENT
            (
                @PROSPECTPLANMANAGERHISTORYID uniqueidentifier,
                @PROSPECTPLANID uniqueidentifier,
                @ISPRIMARYMANAGER bit,
                @DATEFROM datetime,
                @DATETO datetime
            )
            returns bit
            with execute as caller
            as begin

                if exists (
                    select top 1
                        ID
                    from
                        dbo.PROSPECTPLANMANAGERHISTORY
                    where
                        ID <> @PROSPECTPLANMANAGERHISTORYID and
                        PROSPECTPLANID = @PROSPECTPLANID and
                        ISPRIMARYMANAGER = @ISPRIMARYMANAGER and
                        (
                            (@DATEFROM < DATEFROM and @DATETO > DATEFROM) or
                            (@DATEFROM = DATEFROM and @DATETO > @DATEFROM and DATETO > DATEFROM) or
                            (@DATEFROM > DATEFROM and @DATEFROM < DATETO) or
                            (DATEFROM is null and (@DATEFROM is null or @DATEFROM < DATETO)) or
                            (@DATEFROM is null and (DATEFROM is null or DATEFROM < @DATETO))
                        )
                    )
                    return 0;

                return 1;

            end