UFN_SITEID_MAPFROM_CAMPAIGNID

create function [BBDW].[UFN_SITEID_MAPFROM_CAMPAIGNID]  
  (  
    @CAMPAIGNID uniqueidentifier  
  )   
  returns table
    as  

    return

      select cs.[SITESYSTEMID] as [SITEID]
      from BBDW.[DIM_CAMPAIGN] c
      left join BBDW.[FACT_CAMPAIGNSITE] cs on c.[CAMPAIGNDIMID] = cs.[CAMPAIGNDIMID]
      where c.[CAMPAIGNSYSTEMID] = @CAMPAIGNID