UFN_SITEID_MAPFROM_SEGMENTGROUPID

Maps a Segment Group to a Site.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@SEGMENTGROUPID uniqueidentifier IN

Definition

Copy


create function dbo.[UFN_SITEID_MAPFROM_SEGMENTGROUPID]
(
  @SEGMENTGROUPID uniqueidentifier
)
returns uniqueidentifier
as
begin
  declare @SITEID uniqueidentifier;

  select @SITEID = [SITEID] from dbo.[MKTSEGMENTGROUP] where [ID] = @SEGMENTGROUPID;

  return @SITEID;
end