CREATE PROCEDURE dbo.z_test_xml;1
(
    @test_xml    text = 
    '<test_xml>
     <groupnum>1</groupnum>
     <items>
        <item>
            <no>1</no>
        </item>
	    <item>
            <no>2</no>
        </item>
     </items>
     </test_xml>'
)
AS
BEGIN
    DECLARE @groupnum  varchar(10)
    
--xmlextract
    SELECT  @groupnum  =   xmlextract('//groupnum/text()',@test_xml returns varchar(10))

--xmltable        
    SELECT 
            item_no
      FROM
            xmltable('/test_xml/items/item' 
                        passing @test_xml 
                        columns item_no           varchar(30)     path 'no') as items_table
                   
END