USP_HTMLTEMPLATETODOCXMERGE_GETPARAMETERSET

Retrieves the parameter set for the given parameter set id.

Parameters

Parameter	Parameter Type	Mode	Description
@PARAMETERSETID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_HTMLTEMPLATETODOCXMERGE_GETPARAMETERSET
(
    @PARAMETERSETID uniqueidentifier
)
as
begin

    select
        HTMLTEMPLATETODOCXMERGEPROCESS.ID,
        HTMLTEMPLATETODOCXMERGEPROCESS.MKTSEGMENTATIONEXPORTPROCESSSTATUSID,
        MKTSEGMENTATIONEXPORTPROCESSSTATUS.PARAMETERSETID MKTSEGMENTATIONEXPORTPROCESSID,
        MKTSEGMENTATION.NAME MAILINGNAME
    from dbo.HTMLTEMPLATETODOCXMERGEPROCESS
    inner join dbo.MKTSEGMENTATIONEXPORTPROCESSSTATUS
        on HTMLTEMPLATETODOCXMERGEPROCESS.MKTSEGMENTATIONEXPORTPROCESSSTATUSID = MKTSEGMENTATIONEXPORTPROCESSSTATUS.ID
    inner join dbo.MKTSEGMENTATIONEXPORTPROCESS
        on MKTSEGMENTATIONEXPORTPROCESSSTATUS.PARAMETERSETID = MKTSEGMENTATIONEXPORTPROCESS.ID
    inner join dbo.MKTSEGMENTATION
        on MKTSEGMENTATIONEXPORTPROCESS.SEGMENTATIONID = MKTSEGMENTATION.ID
    where HTMLTEMPLATETODOCXMERGEPROCESS.ID = @PARAMETERSETID

end