USP_MKTSEGMENTATIONEXPORTPROCESS_GETLETTERCODES

Retrieves the letter codes for a marketing effort and export definition.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN
@EXPORTDEFINITIONID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTSEGMENTATIONEXPORTPROCESS_GETLETTERCODES]
(
  @SEGMENTATIONID uniqueidentifier,
  @EXPORTDEFINITIONID uniqueidentifier
)
as
begin
  set nocount on;

  select
    [LETTERCODE].[ID],
    [LETTERCODE].[WORDTEMPLATEFILENAME] as [NAME]
  from 
    dbo.[MKTSEGMENTATIONEXPORTPROCESS]
    inner join dbo.[MKTSEGMENTATIONSEGMENT] on [MKTSEGMENTATIONEXPORTPROCESS].[SEGMENTATIONID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID]
    inner join dbo.[MKTPACKAGE] on [MKTSEGMENTATIONSEGMENT].[PACKAGEID] = [MKTPACKAGE].[ID]
    inner join dbo.[LETTERCODE] on [MKTPACKAGE].[LETTERCODEID] = [LETTERCODE].[ID]
  where 
    [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = @SEGMENTATIONID
    and [LETTERCODE].[EXPORTDEFINITIONID] = @EXPORTDEFINITIONID
    and [LETTERCODE].[WORDFILE] is not null
  union
  select
    [LETTERCODE].[ID],
    [LETTERCODE].[WORDTEMPLATEFILENAME] as [NAME]
  from 
    dbo.[MKTSEGMENTATIONEXPORTPROCESS]
    inner join dbo.[MKTSEGMENTATIONSEGMENT] on [MKTSEGMENTATIONEXPORTPROCESS].[SEGMENTATIONID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID]
    inner join dbo.[MKTSEGMENTATIONTESTSEGMENT] on [MKTSEGMENTATIONSEGMENT].[ID] = [MKTSEGMENTATIONTESTSEGMENT].[SEGMENTID]
    inner join dbo.[MKTPACKAGE] on [MKTSEGMENTATIONTESTSEGMENT].[PACKAGEID] = [MKTPACKAGE].[ID]
    inner join dbo.[LETTERCODE] on [MKTPACKAGE].[LETTERCODEID] = [LETTERCODE].[ID]
  where 
    [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = @SEGMENTATIONID
    and [LETTERCODE].[EXPORTDEFINITIONID] = @EXPORTDEFINITIONID
    and [LETTERCODE].[WORDFILE] is not null
end