UFN_SITEID_MAPFROM_PACKAGESEGMENTATIONTEMPLATECONTEXT

Maps a Package within the context of a Marketing Effort Template to a Site.

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@PACKAGESEGMENTATIONTEMPLATECONTEXT	nvarchar(72)	IN

Definition

Copy



create function dbo.[UFN_SITEID_MAPFROM_PACKAGESEGMENTATIONTEMPLATECONTEXT]
(
  @PACKAGESEGMENTATIONTEMPLATECONTEXT nvarchar(72)
)
returns uniqueidentifier
as
begin
  declare @SITEID uniqueidentifier;
  declare @TEMPLATEID uniqueidentifier;

  set @TEMPLATEID = convert(uniqueidentifier, right(@PACKAGESEGMENTATIONTEMPLATECONTEXT, 36));

  if exists (select top 1 1 from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATE] where [ID] = @TEMPLATEID)
    select @SITEID = [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[SITEID] 
    from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATE]
    where [MKTACKNOWLEDGEMENTMAILINGTEMPLATE].[ID] = @TEMPLATEID;
  else if exists (select top 1 1 from dbo.[MKTMEMBERSHIPMAILINGTEMPLATE] where [ID] = @TEMPLATEID)
    select @SITEID = [MKTMEMBERSHIPMAILINGTEMPLATE].[SITEID] 
    from dbo.[MKTMEMBERSHIPMAILINGTEMPLATE]
    where [MKTMEMBERSHIPMAILINGTEMPLATE].[ID] = @TEMPLATEID;
  else if exists (select top 1 1 from dbo.[MKTSPONSORSHIPMAILINGTEMPLATE] where [ID] = @TEMPLATEID)
    select @SITEID = [MKTSPONSORSHIPMAILINGTEMPLATE].[SITEID] 
    from dbo.[MKTSPONSORSHIPMAILINGTEMPLATE]
    where [MKTSPONSORSHIPMAILINGTEMPLATE].[ID] = @TEMPLATEID;
  else
    set @SITEID = '00000000-0000-0000-0000-000000000000';

  return @SITEID;
end