spGetCMSReservedItemCount

Parameters

Parameter	Parameter Type	Mode
@SessionId	nvarchar(50)	IN
@XML	ntext	IN
@Count	int	INOUT

Definition

Copy



        CREATE PROCEDURE [dbo].[spGetCMSReservedItemCount] ( @SessionId NVARCHAR(50) = '',
    @XML NTEXT = '',
    @Count INT output )
    AS
      SET nocount ON
      BEGIN TRANSACTION
      DELETE
      FROM   dbo.cmsreserveditems
      WHERE  expiresat <= Getutcdate()
      DECLARE @idoc INT
      EXEC sp_xml_preparedocument
        @idoc output,
        @XML
      SELECT @Count = Sum(itemqty)
      FROM   dbo.cmsreserveditems
      WHERE  itemid IN
             (
                    SELECT itemid
                    FROM   OPENXML (@idoc, '/ArrayOfReservedItem/ReservedItem', 2) WITH( [ItemQty] INT, [ItemId] INT ) )
      AND    sessionid <> @SessionId
      EXEC sp_xml_removedocument
        @idoc
      COMMIT transaction