UFN_SITEID_MAPFROM_DESIGNATIONID

create function [BBDW].[UFN_SITEID_MAPFROM_DESIGNATIONID]
  (  
    @DESIGNATIONID uniqueidentifier
  )   
  returns uniqueidentifier
    as  

    begin
      declare @ID uniqueidentifier;

      select @ID = d.[SITESYSTEMID]
      from BBDW.[DIM_DESIGNATION] d

      where d.[DESIGNATIONSYSTEMID] = @DESIGNATIONID

      return @ID;
    end