Here is the XML I am trying to extract from 

```
<?xml version="1.0" encoding="utf-16"?>
<dictionary>
<item>
<key><string>MemberNumber</string></key>
<value><string>66962336209</string></value>
</item></dictionary>

```

Create table #1 (ID int identity(1,1), extradata xml)

```
INSERT INTO #1
Select '<dictionary><item><key><string>MemberNumber</string></key><value><string>66962336209</string></value></item></dictionary>'

SELECT extradata.value('/*:dictionary[1]/*:Item[1]/*:Key[1]','NVARCHAR(MAX)')
FROM #1;

select
    a.c.value('*:Value[1]','nvarchar(max)') as [value]
from #1 as t
    outer apply t.extradata.nodes('
        *:dictionary/*:Item[*:Key="code"]'
    ) as a(c)

```

I keep getting NULL values back.

I want to get the key value pairs on two different rows, I can transform the data from there.