USP_MKTSEGMENTATIONACTIVATE_GETIDSETOBJECTNAMES

Retrieves a list of resolved gift ID set object names for other marketing efforts with the same appeal.

Parameters

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

Definition

Copy



CREATE procedure dbo.[USP_MKTSEGMENTATIONACTIVATE_GETIDSETOBJECTNAMES]
(
  @SEGMENTATIONID uniqueidentifier,
  @RECORDSOURCEID uniqueidentifier
)
as
  set nocount on;

  declare @APPEALSYSTEMID nvarchar(36);
  declare @APPEALID nvarchar(100);

  select
    @APPEALSYSTEMID = [APPEALSYSTEMID],
    @APPEALID = replace([APPEALID], '''', '''''')
  from dbo.[MKTSEGMENTATIONACTIVATE]
  where [SEGMENTATIONID] = @SEGMENTATIONID
  and [RECORDSOURCEID] = @RECORDSOURCEID;

  select
    dbo.[UFN_MKTSELECTION_GETFUNCTIONNAME]([NORMALGIFTIDSETREGISTERID]) as [IDSETOBJECTNAME]
  from dbo.[MKTSEGMENTATIONACTIVATE]
  where [SEGMENTATIONID] <> @SEGMENTATIONID
  and [NORMALGIFTIDSETREGISTERID] is not null
  and [RECORDSOURCEID] = @RECORDSOURCEID
  and ([APPEALSYSTEMID] = @APPEALSYSTEMID or [APPEALID] = @APPEALID);

  return 0;