UFN_SITEID_MAPFROM_SEGMENTATIONTESTSEGMENTID

create function [BBDW].[UFN_SITEID_MAPFROM_SEGMENTATIONTESTSEGMENTID]
  (  
    @SEGMENTATIONTESTSEGMENTID 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.[SEGMENTATIONTESTSEGMENTSYSTEMID] = cast(@SEGMENTATIONTESTSEGMENTID as uniqueidentifier);

      return @SITEID;
    end