using xml data type in sql server

See more:

SQL-Server-2012

Hi Team,
I Am using below xml to retrieve data

declare @exp XML

set @exp=
N'<SpItem>
        <SPId>1</SPId>
        <NName>ab</NName>

        <Expr>
            <Oprt> </Oprt>
            <Nr>10</Nr>
            <Oprt>+</Oprt>
            <Data>
                <Type>Mc</Type>
                <Id>10</Id>
                <Value>Mc Value</Value>
            </Data>
            <Oprt>+</Oprt>
            <Data>
                <Type>DataElement</Type>
                <Id>10</Id>
                <Value>Mc Value</Value>
            </Data>
            <Oprt>*</Oprt>

            <SPItem>
                <SPId></SPId>
                <NName>My SPad</NName>
                <Expr>
                    <Oprt>  </Oprt>
                    <Data>
                        <Type>Metric</Type>
                        <Id>10</Id>
                        <Value>Mc Value</Value>
                    </Data>
                </Expr>
            </SPItem>
        </Expr>
</SpItem>'

and i used below query to retrieve

select
col.value('(Oprt/text())[1]','varchar(50)'),
col.value('(text())[1]','varchar(50)')
 from @exp.nodes('//Expr') as tab(col)
 cross apply col.nodes('Data') as dtype(dt)

can any one help me to retrieve all the data from xml. Thanks in advance.