USP_DATALIST_DISCOUNTMEMBER

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

Parameters

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

Definition

Copy



                    create procedure dbo.USP_DATALIST_DISCOUNTMEMBER
                    (
                        @DISCOUNTID uniqueidentifier
                    )
                    as
                        set nocount on;

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

                        return 0;