USP_DATALIST_MKTAPPEALUNRESOLVEDRESPONSESAVAILABLEMAILINGS

Returns a list of other available marketing efforts for a marketing effort's appeal.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_MKTAPPEALUNRESOLVEDRESPONSESAVAILABLEMAILINGS
(
  @SEGMENTATIONID uniqueidentifier
)
as
  set nocount on;

select
  [MKTSEGMENTATION].[ID],
  [MKTSEGMENTATION].[IDINTEGER],
  [MKTSEGMENTATION].[CODE],
  [MKTSEGMENTATION].[NAME],
  [MKTSEGMENTATION].[ACTIVATEDATE],
  [MKTSEGMENTATION].[DESCRIPTION],
  [MKTSEGMENTATION].[MAILDATE]
from 
  dbo.[MKTSEGMENTATIONACTIVATE] as [ACT1]
  inner join dbo.[MKTSEGMENTATIONACTIVATE] as [ACT2] on [ACT1].[RECORDSOURCEID] = [ACT2].[RECORDSOURCEID] and (([ACT1].[APPEALSYSTEMID] = [ACT2].[APPEALSYSTEMID] and len([ACT1].[APPEALSYSTEMID]) > 0) or [ACT1].[APPEALID] = [ACT2].[APPEALID])
  inner join dbo.[MKTSEGMENTATION] on [MKTSEGMENTATION].[ID] = [ACT2].[SEGMENTATIONID]
where 
  [ACT1].[SEGMENTATIONID] = @SEGMENTATIONID
  and [MKTSEGMENTATION].[ACTIVE] = 1  
order by [MKTSEGMENTATION].[NAME];

return 0;