UFN_SALESORDERITEMMEMBER_VALIDMEMBER

Validates that a member is only added to a membership once.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@SALESORDERITEMMEMBERSHIPID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@SALESORDERITEMMEMBERID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SALESORDERITEMMEMBER_VALIDMEMBER
            (
                @SALESORDERITEMMEMBERSHIPID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier,
                @SALESORDERITEMMEMBERID uniqueidentifier
            )
            returns bit
            as begin
                if exists
                (
                    select
                        1
                    from
                        dbo.SALESORDERITEMMEMBER
                    where
                        SALESORDERITEMMEMBERSHIPID = @SALESORDERITEMMEMBERSHIPID
                        and CONSTITUENTID = @CONSTITUENTID
                        and ID <> @SALESORDERITEMMEMBERID
                )
                    return 0;

                return 1;
            end