CREATE PROCEDURE dbo.usp_DeleteLoansFromQueue
@QueueLoanIDs xml
, @QueueID int
AS
--
IF @@ERROR = 0
BEGIN

	DECLARE @x table (v int)

	INSERT INTO @x
	(
		v
	)
	SELECT x.v.value('.', 'Int')
	FROM @QueueLoanIDs.nodes('/v') AS x(v)

	DELETE dbo.QueueLoan
	WHERE QueueID = @QueueID
	AND QueueLoanID IN
					(
						SELECT x.v
						FROM @x AS x
					)
	AND processedDttm IS NULL
	AND checkOutDttm IS NULL

END
--
RETURN @@ERROR
GO