USP_DATALIST_COMBINATIONMEMBER

Displays a list of allowed memberships/levels for a combination.

Parameters

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

Definition

Copy



                    create procedure dbo.USP_DATALIST_COMBINATIONMEMBER
                    (
                        @COMBINATIONID uniqueidentifier
                    )
                    as
                        set nocount on;

                        select COMBINATIONMEMBER.ID,                                                    
                            MEMBERSHIPPROGRAM.NAME [PROGRAMNAME],
                            ISNULL(MEMBERSHIPLEVEL.NAME, '<any level>') [LEVELNAME]
                        from dbo.COMBINATIONMEMBER
                            inner join dbo.MEMBERSHIPPROGRAM
                                on COMBINATIONMEMBER.MEMBERSHIPPROGRAMID = MEMBERSHIPPROGRAM.ID
                            left outer join dbo.MEMBERSHIPLEVEL
                                on COMBINATIONMEMBER.MEMBERSHIPLEVELID = MEMBERSHIPLEVEL.ID
                        where COMBINATIONID = @COMBINATIONID
                        order by COMBINATIONMEMBER.SEQUENCE;

                        return 0;