create procedure [dbo].[BcDequeueTransactionBatchHeader]
    @queueId int
as
begin
    set nocount on

    update BcTransactionBatch
        set CompletedOn = sysdatetimeoffset()
    from BcTransactionBatchQueue
    where
        BcTransactionBatchQueue.BcTransactionBatchQueueId = @queueId and
        BcTransactionBatch.BcTransactionBatchId = BcTransactionBatchQueue.BcTransactionBatchFid

    delete from BcTransactionBatchQueue
    where BcTransactionBatchQueueId = @queueId

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