USP_DATALIST_MEMBERSHIPPROGRAM_SALESBYLEVEL

Returns data about membership sales for a given membership program.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



            create procedure dbo.USP_DATALIST_MEMBERSHIPPROGRAM_SALESBYLEVEL
            (
                @CONTEXTID uniqueidentifier
            )
            as
                set nocount on;

                select count(MS.ID) QUANTITY,
                       ML.NAME MEMBERSHIPLEVEL
                from dbo.MEMBERSHIP MS
                inner join dbo.MEMBERSHIPPROGRAM MP on MS.MEMBERSHIPPROGRAMID = MP.ID
                inner join dbo.MEMBERSHIPLEVEL ML on MS.MEMBERSHIPLEVELID = ML.ID
                where MP.ID = @CONTEXTID and MS.STATUSCODE = 0
                group by ML.NAME