UFN_MEMBER_VALIDNUMBEROFMEMBERS

        CREATE function dbo.UFN_MEMBER_VALIDNUMBEROFMEMBERS
        (
            @MEMBERSHIPID uniqueidentifier
        )
        returns bit
        with execute as caller
        as begin

            declare @MEMBERSALLOWED smallint
            set @MEMBERSALLOWED = dbo.UFN_MEMBER_NUMBEROFMEMBERSALLOWED(@MEMBERSHIPID)

            declare @MEMBERCOUNT smallint

            select @MEMBERCOUNT = count(ID)
            from dbo.MEMBER
            where MEMBERSHIPID = @MEMBERSHIPID 
                and ISDROPPED = 0

            if @MEMBERCOUNT > @MEMBERSALLOWED
                return 0;

            return 1;
        end