USP_MKTSEGMENTATIONPASSIVESEGMENT_PRELOAD

Prepares the public media marketing effort segment add form.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN

Definition

Copy



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

  select
    [SOURCECODEID],
    [SITEID],
    [MAILDATE],
    [ACTIVE],
    [BASECURRENCYID],
    (select [ID] from dbo.[MKTSOURCECODEPARTDEFINITION] where [ITEMTYPECODE] = 2) as [PACKAGEPARTDEFINITIONID],
    dbo.[UFN_MKTSOURCECODEPART_GETITEMLIST2_TOITEMLISTXML]([MKTSEGMENTATION].[ID]) as [ITEMLIST],
    (select [ID] from dbo.[MKTSOURCECODEPARTDEFINITION] where [ITEMTYPECODE] = 3) as [CHANNELPARTDEFINITIONID]
  from dbo.[MKTSEGMENTATION]
  where [ID] = @SEGMENTATIONID;

  return 0;