UFN_MEMBERSHIP_VALIDNUMBEROFCHILDREN

Validates the number of children in a membership.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPLEVELID	uniqueidentifier	IN
@NUMBEROFCHILDREN	smallint	IN

Definition

Copy



        CREATE function dbo.UFN_MEMBERSHIP_VALIDNUMBEROFCHILDREN
        (
            @MEMBERSHIPLEVELID uniqueidentifier,
            @NUMBEROFCHILDREN smallint
        )
        returns bit
        with execute as caller
        as begin
            --if @NUMBEROFCHILDREN = 0

                --return 1;

            --else 

            if @NUMBEROFCHILDREN < 0
                return 0;

            declare @CHILDRENALLOWED smallint

            select @CHILDRENALLOWED = CHILDRENALLOWED
            from dbo.MEMBERSHIPLEVEL
            where ID = @MEMBERSHIPLEVELID

            if @NUMBEROFCHILDREN > @CHILDRENALLOWED --and @CHILDRENALLOWED > 0

                return 0;

            return 1;
        end