UFN_SITEID_MAPFROM_REGISTRANTID

CREATE function BBDW.[UFN_SITEID_MAPFROM_REGISTRANTID] (@REGISTRANTID [uniqueidentifier]) 
  returns table  
    as    
    return  
      select e.[SITESYSTEMID] as [SITEID]
      from BBDW.[FACT_EVENTREGISTRANT] r
      left join BBDW.[FACT_EVENTSITE] e on r.[EVENTDIMID] = e.[EVENTDIMID]
      where r.[EVENTREGISTRANTSYSTEMID] = @REGISTRANTID;