USP_DATALIST_MKTMEMBERSHIPMAILINGTEMPLATERULE

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPMAILINGTEMPLATEID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.[USP_DATALIST_MKTMEMBERSHIPMAILINGTEMPLATERULE]
(
  @MEMBERSHIPMAILINGTEMPLATEID uniqueidentifier = null,
  @CURRENTAPPUSERID uniqueidentifier = null
)
as
  set nocount on;

  select
    [R].[ID],
    [R].[SEQUENCE],
    [MKTSEGMENT].[NAME] as [SEGMENT],
    [MKTPACKAGE].[NAME] as [PACKAGE],
    [MKTPACKAGE].[CHANNEL],
    [MKTASKLADDER].[NAME] as [ASKLADDER],
    dbo.[UFN_MKTMEMBERSHIPMAILINGTEMPLATE_BUILDSOURCECODE]([R].[ID], [MKTSEGMENT].[QUERYVIEWCATALOGID], default) as [SOURCECODE],
    [R].[RESPONSERATE],
    [R].[GIFTAMOUNT],
    [MKTSEGMENT].[ID] [SEGMENTID],
    [R].[BASECURRENCYID],
    [R].[EXCLUDE]
  from 
    dbo.[MKTMEMBERSHIPMAILINGTEMPLATERULE] as [R]
  inner join 
    dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [R].[SEGMENTID]
  left outer join 
    dbo.[MKTPACKAGE] on [MKTPACKAGE].[ID] = [R].[PACKAGEID]
  left outer join 
    dbo.[MKTASKLADDER] on [MKTASKLADDER].[ID] = [R].[ASKLADDERID]
  where 
    (@MEMBERSHIPMAILINGTEMPLATEID is null or [R].[MEMBERSHIPMAILINGTEMPLATEID] = @MEMBERSHIPMAILINGTEMPLATEID)
  order by [R].[SEQUENCE];

  return 0;