UFN_MKTSEGMENTLIST_GETCURRENTID

Returns the current list segment ID for the specified segment.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@SEGMENTID uniqueidentifier IN

Definition

Copy


CREATE function dbo.[UFN_MKTSEGMENTLIST_GETCURRENTID]
(
  @SEGMENTID uniqueidentifier
)
returns uniqueidentifier
as
begin
  return (select [CURRENTSEGMENTLISTID]
          from dbo.[MKTSEGMENT]
          where [ID] = @SEGMENTID);
end