USP_GETMERGEOUTPUTIDS_FROMACTIVATESTATUSID
Retrieves the html template to docx merge output ids (archived output and aggregate) from the associate segmentation activate status id.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @ARCHIVEDOUTPUTID | uniqueidentifier | INOUT | |
| @AGGREGATEOUTPUTID | uniqueidentifier | INOUT |
Definition
Copy
CREATE procedure dbo.USP_GETMERGEOUTPUTIDS_FROMACTIVATESTATUSID
(
@ID uniqueidentifier,
@ARCHIVEDOUTPUTID uniqueidentifier output,
@AGGREGATEOUTPUTID uniqueidentifier output
)
as
begin
set nocount on;
select
@ARCHIVEDOUTPUTID = ARCHIVEDOUTPUT.ID,
@AGGREGATEOUTPUTID = AGGREGATEOUTPUT.ID
from dbo.HTMLTEMPLATETODOCXMERGEPROCESS
inner join dbo.HTMLTEMPLATETODOCXMERGEPROCESSSTATUS
on HTMLTEMPLATETODOCXMERGEPROCESSSTATUS.PARAMETERSETID = HTMLTEMPLATETODOCXMERGEPROCESS.ID
inner join dbo.MKTSEGMENTATIONACTIVATEEXPORTLINK
on MKTSEGMENTATIONACTIVATEEXPORTLINK.EXPORTPROCESSSTATUSID = HTMLTEMPLATETODOCXMERGEPROCESS.MKTSEGMENTATIONEXPORTPROCESSSTATUSID
left outer join dbo.HTMLTEMPLATEMERGETODOCXOUTPUT as ARCHIVEDOUTPUT
on ARCHIVEDOUTPUT.HTMLTEMPLATETODOCXMERGEPROCESSSTATUSID = HTMLTEMPLATETODOCXMERGEPROCESSSTATUS.ID and ARCHIVEDOUTPUT.ISARCHIVE = 1
left outer join dbo.HTMLTEMPLATEMERGETODOCXOUTPUT as AGGREGATEOUTPUT
on AGGREGATEOUTPUT.HTMLTEMPLATETODOCXMERGEPROCESSSTATUSID = HTMLTEMPLATETODOCXMERGEPROCESSSTATUS.ID and AGGREGATEOUTPUT.ISARCHIVE = 0
where MKTSEGMENTATIONACTIVATEEXPORTLINK.ID = @ID
end