CREATE procedure [dbo].[XLedgerDequeueJournalEntryBatchHeader]
    @queueId int
as
begin
set nocount on
    update XLedgerJournalEntryBatch set CompletedOn = sysdatetimeoffset()
    from XLedgerJournalEntryBatchQueue
    inner join XLedgerJournalEntryBatch on
        XLedgerJournalEntryBatchQueue.XLedgerJournalEntryBatchFid = XLedgerJournalEntryBatch.XLedgerJournalEntryBatchId
    where XLedgerJournalEntryBatchQueue.XLedgerJournalEntryBatchQueueId = @queueId

    delete from XLedgerJournalEntryBatchQueue
    where XLedgerJournalEntryBatchQueueId = @queueId


end
GO
GRANT EXECUTE ON  [dbo].[XLedgerDequeueJournalEntryBatchHeader] TO [MssExec]
GO