UFN_MKTSEGMENTATION_GETACTIVATIONPROCESSID

Returns the activation process ID for a given segmentation ID.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@SEGMENTATIONID uniqueidentifier IN

Definition

Copy


create function dbo.[UFN_MKTSEGMENTATION_GETACTIVATIONPROCESSID]
(
  @SEGMENTATIONID uniqueidentifier
)
returns uniqueidentifier
as
begin
  return
  (
    select [ID]
    from dbo.[MKTSEGMENTATIONACTIVATEPROCESS]
    where [SEGMENTATIONID] = @SEGMENTATIONID
  );
end