fm_queue_dequeue.sql

If Exists (Select * From sysobjects Where name = N'fm_queue_dequeue' And user_name(uid) = N'dbo')
    Drop Procedure dbo.fm_queue_dequeue
Go

CREATE Procedure fm_queue_dequeue
(
     @bibNo integer,
       @borrowerNo integer output,
       @location varchar(64) output,
       @comment varchar(255) output
)
As
   set nocount on

   Declare @reqno int
   
   Select @reqno = request#, @borrowerNo = borrower#, 
          @location = pickup_location, @comment = comment
       from request where bib# = @bibNo and req_queue_ord = 1
   
   Delete from request where request# = @reqno

Go