USP_DATALIST_MKTSPONSORSHIPMAILINGTEMPLATERULE

Parameters

Parameter	Parameter Type	Mode	Description
@SPONSORSHIPMAILINGTEMPLATEID	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_MKTSPONSORSHIPMAILINGTEMPLATERULE]
(
  @SPONSORSHIPMAILINGTEMPLATEID 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_MKTSPONSORSHIPMAILINGTEMPLATE_BUILDSOURCECODE]([R].[ID], [MKTSEGMENT].[QUERYVIEWCATALOGID], default) as [SOURCECODE],
    [R].[RESPONSERATE],
    [R].[GIFTAMOUNT],
    [MKTSEGMENT].[ID] [SEGMENTID],
    [R].[BASECURRENCYID],
    [R].[EXCLUDE]
  from dbo.[MKTSPONSORSHIPMAILINGTEMPLATERULE] 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 (@SPONSORSHIPMAILINGTEMPLATEID is null or [R].[SPONSORSHIPMAILINGTEMPLATEID] = @SPONSORSHIPMAILINGTEMPLATEID)
  order by [R].[SEQUENCE];

  return 0;