UFN_LETTERCODE_GETOBSOLETEMKTEXPORTDEFINITIONID

Attempts to determine the value that the obsolete MKTEXPORTDEFINITIONID column might have held.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@EXPORTDEFINITIONID uniqueidentifier IN

Definition

Copy


create function dbo.[UFN_LETTERCODE_GETOBSOLETEMKTEXPORTDEFINITIONID]
(
  @EXPORTDEFINITIONID uniqueidentifier
)
returns uniqueidentifier
as
  begin
    declare @MKTEXPORTDEFINITIONID uniqueidentifier;

    select @MKTEXPORTDEFINITIONID = [ID]
    from dbo.[MKTEXPORTDEFINITION]
    where [EXPORTDEFINITIONID] = @EXPORTDEFINITIONID;

    return @MKTEXPORTDEFINITIONID;
  end