UFN_SITEID_MAPFROM_PROSPECTPLANID

create function [BBDW].[UFN_SITEID_MAPFROM_PROSPECTPLANID]  
  (  
    @PROSPECTPLANID uniqueidentifier  
  )   
  returns table
    as  

    return

      select ps.[SITESYSTEMID] as [SITEID]
      from BBDW.[DIM_PROSPECTPLAN] p
      left join BBDW.[FACT_PROSPECTPLANSITE] ps on p.[PROSPECTPLANDIMID] = ps.[PROSPECTPLANDIMID]
      where p.[PROSPECTPLANSYSTEMID] = @PROSPECTPLANID