UFN_SITEID_MAPFROM_APPEALID

create function [BBDW].[UFN_SITEID_MAPFROM_APPEALID]
  (  
    @APPEALID uniqueidentifier  
  )   
  returns uniqueidentifier
    as  

    begin
      declare @ID uniqueidentifier;
      select @ID = case when [SITESYSTEMID] <> '00000000-0000-0000-0000-000000000000' then [SITESYSTEMID] else null end from BBDW.[DIM_APPEAL] where [APPEALSYSTEMID] = @APPEALID;
      return @ID
    end