Anonymous

CREATE PROCEDURE dbo.usp_DeleteLoansFromQueue@QueueLoanIDs xml, @QueueID intAS--IF @@ERROR = 0BEGIN	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 NULLEND--RETURN @@ERRORGO