UFN_SITEID_MAPFROM_NAMESCHEMEID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@COMMUNICATIONNAMESCHEMEID uniqueidentifier IN

Definition

Copy


CREATE function dbo.[UFN_SITEID_MAPFROM_NAMESCHEMEID]
(  
  @COMMUNICATIONNAMESCHEMEID uniqueidentifier
)   
returns uniqueidentifier
as
begin
  declare @SITEID uniqueidentifier;

  select @SITEID = [SITEID] from dbo.[MKTCOMMUNICATIONNAMESCHEME] where [ID] = @COMMUNICATIONNAMESCHEMEID;

  return @SITEID;
end