USP_DATALIST_MEMBERSHIPPROGRAMENDDATE

Displays the list of membership expiration dates for a program.

Parameters

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

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_MEMBERSHIPPROGRAMENDDATE
                (
                    @MEMBERSHIPPROGRAMID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        ME.ID,
                        ME.EXPIRATIONDATE,
                        ME.PUSHNEXTDATE,
                        ME.SEQUENCE
                    from 
                        dbo.MEMBERSHIPPROGRAMENDDATE ME
                    where 
                        MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID