UFN_MKTSEGMENTATIONSEGMENT_ISVENDORMANAGEDLIST

Returns whether or not a marketing effort segment is a vendor managed list segment.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@SEGMENTATIONSEGMENTID uniqueidentifier IN

Definition

Copy


CREATE function dbo.[UFN_MKTSEGMENTATIONSEGMENT_ISVENDORMANAGEDLIST]
(
  @SEGMENTATIONSEGMENTID uniqueidentifier
)
returns bit
as
begin
  return
  (
    select dbo.[UFN_MKTSEGMENT_ISVENDORMANAGEDLIST]([SEGMENTID])
    from dbo.[MKTSEGMENTATIONSEGMENT]
    where [MKTSEGMENTATIONSEGMENT].[ID] = @SEGMENTATIONSEGMENTID
  );
end