UFN_SITEID_MAPFROM_EVENTID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy


create function [BBDW].[UFN_SITEID_MAPFROM_EVENTID]  
  (  
    @EVENTID uniqueidentifier  
  )   
  returns table
    as  

    return

      select es.[SITESYSTEMID] as [SITEID]
      from BBDW.[DIM_EVENT] e
      left join BBDW.[FACT_EVENTSITE] es on e.[EVENTDIMID] = es.[EVENTDIMID]
      where e.[EVENTSYSTEMID] = @EVENTID