UFN_SITEID_MAPFROM_SEGMENTID

create function BBDW.[UFN_SITEID_MAPFROM_SEGMENTID] (@SEGMENTID uniqueidentifier)

  returns uniqueidentifier

    as

      begin

        declare @SITEID uniqueidentifier;

        select @SITEID = s.[SITESYSTEMID]
        from BBDW.[DIM_MARKETINGSEGMENT] m
        inner join BBDW.[DIM_SITE] s on m.[SEGMENTSITEDIMID] = s.[SITEDIMID]
        where m.[SEGMENTSYSTEMID] = @SEGMENTID;

        return @SITEID;

end