UFN_SITEID_MAPFROM_MARKETINGPLANTEMPLATEID

Maps a Marketing Plan Template to a Site.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@MARKETINGPLANTEMPLATEID uniqueidentifier IN

Definition

Copy


CREATE function dbo.UFN_SITEID_MAPFROM_MARKETINGPLANTEMPLATEID
(
  @MARKETINGPLANTEMPLATEID uniqueidentifier
)
returns uniqueidentifier
as
begin
  declare @SITEID uniqueidentifier;

  select @SITEID = [SITEID] from dbo.[MKTMARKETINGPLANTEMPLATE] where [ID] = @MARKETINGPLANTEMPLATEID;

  return @SITEID;
end