UFN_SITEID_MAPFROM_SEGMENTATIONSEGMENTID

create function [BBDW].[UFN_SITEID_MAPFROM_SEGMENTATIONSEGMENTID]
  (  
    @SEGMENTATIONSEGMENTID nvarchar(36)
  )   
  returns uniqueidentifier
    as  

    begin
      declare @SITEID uniqueidentifier;

      select @SITEID = s.[SITESYSTEMID]
      from BBDW.[DIM_MARKETINGSEGMENT] ms
      inner join BBDW.[DIM_SITE] s on ms.[SEGMENTATIONSITEDIMID] = s.[SITEDIMID]

      where ms.[SEGMENTATIONSEGMENTSYSTEMID] = cast(@SEGMENTATIONSEGMENTID as uniqueidentifier);

      return @SITEID;
    end