DECLARE @DocHandle int  
DECLARE @XmlDocument nvarchar(1000)  
SET @XmlDocument = N'<registry_record>
      <cad_links>
        <old_numbers>
          <old_number>
            <number>037:015-6893</number>
            <number_type>
              <code>01</code>
              <value>Инвентарный номер</value>
            </number_type>
          </old_number>
          <old_number>
            <number>50-50-50/021/2011-160</number>
            <number_type>
              <code>02</code>
              <value>Условный номер</value>
            </number_type>
          </old_number>
        </old_numbers>
      </cad_links>
</registry_record>';

EXEC sp_xml_preparedocument @DocHandle OUTPUT, @XmlDocument  

	SELECT 
		*
	FROM OPENXML (@DocHandle, 'registry_record/cad_links/old_numbers/old_number/.')  
		WITH (
			  [Number]    nvarchar(50)	'number/.',
			  [code]      nvarchar(50)	'number_type/code/.'
		      )

EXEC sp_xml_removedocument @DocHandle