UFN_SALESORDERITEMMEMBERSHIP_MEMBERSHIPIDCOUNT

Returns the number of renew/rejoins for a membership on a single sales order.

Return

Return Type
tinyint

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPID	uniqueidentifier	IN
@SALESORDERITEMID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_SALESORDERITEMMEMBERSHIP_MEMBERSHIPIDCOUNT
            (
                @MEMBERSHIPID uniqueidentifier,
                @SALESORDERITEMID uniqueidentifier
            )
            returns tinyint
            as begin
                declare @SALESORDERID uniqueidentifier = (select SALESORDERID from dbo.SALESORDERITEM where ID = @SALESORDERITEMID)

                declare @COUNT tinyint;

                select
                    @COUNT = count(SALESORDERITEMMEMBERSHIP.MEMBERSHIPID)
                from
                    dbo.SALESORDERITEMMEMBERSHIP
                inner join
                    dbo.SALESORDERITEM on SALESORDERITEMMEMBERSHIP.ID = SALESORDERITEM.ID
                where
                    SALESORDERITEMMEMBERSHIP.MEMBERSHIPID = @MEMBERSHIPID and SALESORDERITEM.SALESORDERID = @SALESORDERID
                group by
                    SALESORDERITEM.SALESORDERID;

                return @COUNT;
            end