CREATE procedure [dbo].[BcGetNextEnqueuedTransactionBatchHeader]
as
begin
    set nocount on

    select top 1
        QueueId = BcTransactionBatchQueue.BcTransactionBatchQueueId,
        BatchId = BcTransactionBatch.BcTransactionBatchId,
        [Description] = BcTransactionBatch.[Description]
    from BcTransactionBatchQueue
    inner join BcTransactionBatch on BcTransactionBatchQueue.BcTransactionBatchFid = BcTransactionBatch.BcTransactionBatchId
    order by BcTransactionBatchQueue.BcTransactionBatchQueueId asc

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