USP_SIMPLEDATALIST_MEMBERSHIPRENEWALEFFORTFORMEMBERSHIPPROGRAM

CREATE procedure dbo.USP_SIMPLEDATALIST_MEMBERSHIPRENEWALEFFORTFORMEMBERSHIPPROGRAM 
(
    @MEMBERSHIPPROGRAMID uniqueidentifier = null
)
as
    select 
        [MKTMEMBERSHIPMAILINGPROCESS].[ID] as VALUE, 
        [MKTMEMBERSHIPMAILINGTEMPLATE].[NAME] as LABEL
    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
    order by [APPEAL].[NAME]