UFN_SALESOREDERITEMMEMBERSHIPCARD_VALIDNUMBEROFCARDS

            CREATE function dbo.UFN_SALESOREDERITEMMEMBERSHIPCARD_VALIDNUMBEROFCARDS
            (
                @SALESORDERITEMMEMBERID uniqueidentifier
            )
            returns bit
            as begin
                declare @MEMBERSHIPID uniqueidentifier;
                declare @CARDSALLOWED smallint;

                select
                    @MEMBERSHIPID = SALESORDERITEMMEMBER.SALESORDERITEMMEMBERSHIPID,
                    @CARDSALLOWED = MEMBERSHIPLEVEL.CARDSALLOWED
                from
                    dbo.SALESORDERITEMMEMBER
                inner join
                    dbo.SALESORDERITEMMEMBERSHIP on SALESORDERITEMMEMBER.SALESORDERITEMMEMBERSHIPID = SALESORDERITEMMEMBERSHIP.ID
                inner join
                    dbo.MEMBERSHIPLEVEL on SALESORDERITEMMEMBERSHIP.MEMBERSHIPLEVELID = MEMBERSHIPLEVEL.ID
                where
                    SALESORDERITEMMEMBER.ID = @SALESORDERITEMMEMBERID;

                declare @CARDCOUNT smallint;

                select
                    @CARDCOUNT = count(SALESORDERITEMMEMBERSHIPCARD.ID)
                from
                    dbo.SALESORDERITEMMEMBERSHIPCARD
                inner join
                    dbo.SALESORDERITEMMEMBER on SALESORDERITEMMEMBER.ID = SALESORDERITEMMEMBERSHIPCARD.SALESORDERITEMMEMBERID
                where
                    SALESORDERITEMMEMBER.SALESORDERITEMMEMBERSHIPID = @MEMBERSHIPID;

                if @CARDCOUNT > @CARDSALLOWED --and @CARDSALLOWED > 0

                    return 0;

                return 1;
            end