USP_DATALIST_MEMBERSHIPRENEWALEFFORTTEMPLATEAPPEAL

Gets the list of membership renewal effort template and appeal for a membership 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_MEMBERSHIPRENEWALEFFORTTEMPLATEAPPEAL(@MEMBERSHIPPROGRAMID uniqueidentifier)
as
    set nocount on;

    select 
        [MKTMEMBERSHIPMAILINGPROCESS].[ID] as MEMBERSHIPRENEWALEFFORTPROCESSID, 
        [MKTMEMBERSHIPMAILINGTEMPLATE].[ID] as MEMBERSHIPRENEWALEFFORTTEMPLATEID,
        [MKTMEMBERSHIPMAILINGTEMPLATE].[NAME] as MEMBERSHIPRENEWALEFFORTTEMPLATENAME,
        [APPEAL].[ID] AS APPEALID,
        [APPEAL].[NAME] AS APPEALNAME
    from dbo.[MKTMEMBERSHIPMAILINGTEMPLATE]
    inner join dbo.[MKTMEMBERSHIPMAILINGPROCESS] 
        on [MKTMEMBERSHIPMAILINGPROCESS].[MEMBERSHIPMAILINGTEMPLATEID] = [MKTMEMBERSHIPMAILINGTEMPLATE].[ID]
    inner join dbo.[MKTMEMBERSHIPMAILINGTEMPLATEAPPEAL] 
        on [MKTMEMBERSHIPMAILINGTEMPLATEAPPEAL].[MEMBERSHIPMAILINGTEMPLATEID] = [MKTMEMBERSHIPMAILINGTEMPLATE].[ID]
    inner join dbo.[APPEAL] on [APPEAL].[ID] = case [MKTMEMBERSHIPMAILINGTEMPLATEAPPEAL].[APPEALSYSTEMID]
                                                                when '' then '00000000-0000-0000-0000-000000000000'
                                                                else [MKTMEMBERSHIPMAILINGTEMPLATEAPPEAL].[APPEALSYSTEMID]
                                                            end
    where [APPEAL].[MEMBERSHIPPROGRAMID] = @MEMBERSHIPPROGRAMID