Open Xml Document in Store Procedure for bulk update?

sp_helptext DeleteCmsComplianceType_Sp

CREATE  PROCEDURE DeleteCmsComplianceType_Sp                          
(           
@rtnVal int,                         
@xmlCTypeId nvarchar(max)        
)                            
AS                            
BEGIN         
  DECLARE @hdoc1 int                    
     EXEC sp_xml_preparedocument @hdoc1 OUTPUT, @xmlCTypeId           
   
Insert into T1SP1(id,name) select * from  OPENXML(@index, '/data/ids') WITH (id INT,name varchar(50))
EXEC sp_xml_removedocument @hdoc1        
set @rtnVal=1        
END        
return @rtnVal