declare @h int, @x xml ='<ROOT><FIRST>
        	<DATA>2021-11-21</DATA>
        	<NUM>NUM1</NUM>
        	<SECOND>
        		<SECOND_NAME>AAA</SECOND_NAME>
        		<SECOND_DATE>2019-10-01</SECOND_DATE>
        		<METHOD>2</METHOD>
        	</SECOND>        	
        	<SECOND>
        		<SECOND_NAME>BBB</SECOND_NAME>
        		<SECOND_DATE>2019-10-01</SECOND_DATE>
        		<METHOD>3</METHOD>
        	</SECOND>        	
        </FIRST>
        <FIRST>
        	<DATA>2021-11-22</DATA>
        	<NUM>NUM2</NUM>
        </FIRST></ROOT>';

exec sys.sp_xml_preparedocument @h output, @xml;

select * from openxml(@h, '/ROOT/FIRST') with (NUM varchar(30) 'NUM', DATA varchar(30) 'DATA');
select * from openxml(@h, '/ROOT/FIRST/SECOND')
with
(
 NUM varchar(30) '../NUM',
 SECOND_NAME varchar(30) 'SECOND_NAME',
 SECOND_DATE varchar(30) 'SECOND_DATE',
 METHOD varchar(30) 'METHOD'
);

exec sys.sp_xml_removedocument @h;