UFN_SITEID_MAPFROM_CONSTITUENTID

create function BBDW.[UFN_SITEID_MAPFROM_CONSTITUENTID]
(
  @CONSTITUENTID uniqueidentifier
)
returns table
as
  return (
    select
      [SITESYSTEMID] as [SITEID]
    from (select @CONSTITUENTID as [CONSTITUENTID]) as T
    left outer join BBDW.[FACT_CONSTITUENTSITE] on [FACT_CONSTITUENTSITE].[CONSTITUENTSYSTEMID] = T.[CONSTITUENTID]
  );