USP_DATAFORMTEMPLATE_ADD_BATCHTICKETPRINTJOB_PRELOAD

CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BATCHTICKETPRINTJOB_PRELOAD (
    @DELIVERYMETHODID uniqueidentifier = null output,
    @DOCUMENTID uniqueidentifier = null output,
    @RECENTLYUSEDDOCUMENTS xml = null output
)
as
    set nocount on;

    select top 1
        @DELIVERYMETHODID = DELIVERYMETHODID,
        @DOCUMENTID = DOCUMENTID
    from
        dbo.BATCHTICKETPRINTJOB
    order by
        PRINTDATEWITHTIMEOFFSET desc;

    set @RECENTLYUSEDDOCUMENTS = (
        select
            BATCHTICKETPRINTJOB.ID,
            BATCHTICKETPRINTJOB.DELIVERYMETHODID,
            BATCHTICKETPRINTJOB.DOCUMENTID
        from
            dbo.BATCHTICKETPRINTJOB
        inner join (
            select
                DELIVERYMETHODID,
                max(PRINTDATEWITHTIMEOFFSET) as LATESTPRINTDATEWITHTIMEOFFSET
            from
                dbo.BATCHTICKETPRINTJOB
            group by
                DELIVERYMETHODID
        ) as LATESTDELIVERYMETHODDATE
            on LATESTDELIVERYMETHODDATE.LATESTPRINTDATEWITHTIMEOFFSET = BATCHTICKETPRINTJOB.PRINTDATEWITHTIMEOFFSET
                and (
                    LATESTDELIVERYMETHODDATE.DELIVERYMETHODID = BATCHTICKETPRINTJOB.DELIVERYMETHODID
                    or (LATESTDELIVERYMETHODDATE.DELIVERYMETHODID is null and BATCHTICKETPRINTJOB.DELIVERYMETHODID is null)
                )
        for xml raw('ITEM'), type, elements, root('RECENTLYUSEDDOCUMENTS'), binary base64
    );

    return 0;