CREATE PROCEDURE [dbo].[XLedgerGetNextEnqueuedJournalEntryBatchHeader]
as
begin
    set nocount on
    select top 1
            QueueId = XLedgerJournalEntryBatchQueue.XLedgerJournalEntryBatchQueueId,
            JournalEntryBatchHeaderId = XLedgerJournalEntryBatch.XLedgerJournalEntryBatchId,
            [Description] = XLedgerJournalEntryBatch.[Description]
        from XLedgerJournalEntryBatchQueue
        inner join XLedgerJournalEntryBatch on
            XLedgerJournalEntryBatchQueue.XLedgerJournalEntryBatchFid = XLedgerJournalEntryBatch.XLedgerJournalEntryBatchId
        where XLedgerJournalEntryBatchQueue.Processed = 0
        order by XLedgerJournalEntryBatchQueue.XLedgerJournalEntryBatchQueueId asc
end
GO
GRANT EXECUTE ON  [dbo].[XLedgerGetNextEnqueuedJournalEntryBatchHeader] TO [MssExec]
GO