USP_DATAFORMTEMPLATE_VIEW_LATESTCOMMUNICATIONOUTPUTID

CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_LATESTCOMMUNICATIONOUTPUTID
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @FILENAME nvarchar(255) = null output,
    @OUTPUTID uniqueidentifier = null output
)
as
    set nocount on;

    set @DATALOADED = 0;

    select top 1
        @DATALOADED = 1,
        @FILENAME = HTMLTEMPLATEMERGETODOCXOUTPUT.FILENAME,
        @OUTPUTID = HTMLTEMPLATEMERGETODOCXOUTPUT.ID        
    from dbo.MKTSEGMENTATIONACTIVATEEXPORTLINK
    inner join dbo.HTMLTEMPLATETODOCXMERGEPROCESS
        on MKTSEGMENTATIONACTIVATEEXPORTLINK.EXPORTPROCESSSTATUSID = HTMLTEMPLATETODOCXMERGEPROCESS.MKTSEGMENTATIONEXPORTPROCESSSTATUSID
    inner join dbo.HTMLTEMPLATETODOCXMERGEPROCESSSTATUS 
        on HTMLTEMPLATETODOCXMERGEPROCESSSTATUS.PARAMETERSETID = HTMLTEMPLATETODOCXMERGEPROCESS.ID
    inner join dbo.HTMLTEMPLATEMERGETODOCXOUTPUT 
        on HTMLTEMPLATEMERGETODOCXOUTPUT.HTMLTEMPLATETODOCXMERGEPROCESSSTATUSID = HTMLTEMPLATETODOCXMERGEPROCESSSTATUS.ID
    where MKTSEGMENTATIONACTIVATEEXPORTLINK.ID = @ID
    order by HTMLTEMPLATEMERGETODOCXOUTPUT.ISARCHIVE desc;

    return 0;