UFN_SITEID_MAPFROMTRIBUTEID

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@TRIBUTEID	uniqueidentifier	IN

Definition

Copy


create function BBDW.[UFN_SITEID_MAPFROMTRIBUTEID]
    (@TRIBUTEID uniqueidentifier)

    returns table 

  as

  return

  (
    select
      ts.[SITESYSTEMID] as [SITEID]
    from BBDW.[DIM_TRIBUTE] t
    left join BBDW.[FACT_TRIBUTESITE] ts on t.[TRIBUTEDIMID] = ts.[TRIBUTEDIMID]
    where t.[TRIBUTESYSTEMID] = @TRIBUTEID
  );