CREATE PROCEDURE dbo.my_Procedure_Outer
     ...
     ...
     @XMLSTR TEXT = NULL, -- Строка XML

DECLARE @RESULT INT,
, @AktMBPRash_ID INT
, @Ost_ID_Rash INT
, @Kvo_Need DECIMAL( 18 , 3 )
, @TYPE_IN_DOK TINYINT
, @PART_STR_ID INT
...
...
EXEC @RESULT = sp_xml_preparedocument @IDXML_LINE  OUTPUT, @XMLSTR
IF (@RESULT <>  0 ) OR (@IDXML_LINE IS NULL)
BEGIN
	ROLLBACK TRANSACTION
	RAISERROR('Ошибка обработки XML',  16 ,  1 )
	RETURN (- 1 ) 
END
DECLARE Docum CURSOR FORWARD_ONLY LOCAL STATIC FOR
  SELECT aktmbprash_id, ostatok_id, kvo_need, type_in_dok, part_str_id
  FROM OPENXML ( @IDXML_LINE, '/VFPData/listout',  2 )
  WITH (aktmbprash_id int, ostatok_id int, kvo_need decimal( 18 , 3 ), type_in_dok tinyint, part_str_id int)
  ORDER BY kvo_need DESC
OPEN Docum
FETCH NEXT FROM Docum INTO @AktMBPRash_ID, @Ost_ID_Rash, @Kvo_Need, @TYPE_IN_DOK, @PART_STR_ID
WHILE @@FETCH_STATUS =  0 
BEGIN
...
...
  EXEC @RET_CODE = my_Procedure_Inner  @AktMBPRash_ID, @Ost_ID_Rash, @Kvo_Need,   @TYPE_IN_DOK,  @PART_STR_ID
IF @RET_CODE <  0 
BEGIN
   IF @@TRANCOUNT <>  0 
        ROLLBACK TRANSACTION
   RAISERROR('Ошибка тра-та-та для AktMBPRash_ID=%d!',  16 ,  1 , @AktMBPRash_ID)
   RETURN (- 1 )
END
...
  FETCH NEXT FROM Docum INTO @AktMBPRash_ID, @Ost_ID_Rash, @Kvo_Need, @TYPE_IN_DOK,   @PART_STR_ID
END
CLOSE Docum
DEALLOCATE Docum
EXEC sp_xml_removedocument @IDXML_LINE
...
...