Here's what worked for me:-
CREATE TABLE [dbo].[XML_Convert](
[Kachunk] [xml] NULL
) ON [PRIMARY]
GO
DECLARE @Text XML
SET @Text =
'<SEARCHREQUESTRESULT><DOCUMENTS>
<DOCUMENTDETAIL>
<DOCUMENTDATE/>
<CONSIDERATIONAMOUNT>0</CONSIDERATIONAMOUNT>
<BOOK/>
<PAGE/>
<REFERENCENUMBER/>
<NOTES/>
<RETURNEDTO/>
<PARTIES>
<PARTY>
<ID>1090</ID>
<NAME>MORTGAGE ELECTRONIC REGISTRATION SYSTEM</NAME>
<ADDITIONALNAME/>
<PARTYTYPEID>1</PARTYTYPEID>
<TYPE/>
<ADDRESS1/>
<ADDRESS2/>
<CITY/>
<STATE/>
<ZIPCODE/>
<ATTRIBUTE/>
<SESSIONID>0</SESSIONID>
</PARTY>
<PARTY>
<ID>1091</ID>
<NAME>GATES</NAME>
<ADDITIONALNAME>DANIEL</ADDITIONALNAME>
<PARTYTYPEID>2</PARTYTYPEID>
<TYPE/>
<ADDRESS1/>
<ADDRESS2/>
<CITY/>
<STATE/>
<ZIPCODE/>
<ATTRIBUTE/>
<SESSIONID>0</SESSIONID>
</PARTY>
<PARTY>
<ID>1092</ID>
<NAME>GATES</NAME>
<ADDITIONALNAME>KIMBERLY</ADDITIONALNAME>
<PARTYTYPEID>2</PARTYTYPEID>
<TYPE/>
<ADDRESS1/>
<ADDRESS2/>
<CITY/>
<STATE/>
<ZIPCODE/>
<ATTRIBUTE/>
<SESSIONID>0</SESSIONID>
</PARTY>
</PARTIES>
<LEGALS>
<LEGALBASE>
<ID>65</ID>
<DESCRIPTION>344 BRANDY RIDGE LANE, LEAGUE CITY, TX 77573</DESCRIPTION>
<NOTES/>
<PROPERTYNOTES/>
<LEGALTYPE>A</LEGALTYPE>
<SESSIONID>0</SESSIONID>
</LEGALBASE>
</LEGALS>
<LEGALDETAILS>
<ADDRESSLEGAL>
<HOUSENUMBER>344</HOUSENUMBER>
<STREET>BRANDY RIDGE LANE</STREET>
<STREETDIRECTION/>
<CITY>LEAGUE CITY</CITY>
<STATE>TX</STATE>
<ZIPCODE>77573</ZIPCODE>
<ID>65</ID>
<DESCRIPTION>344 BRANDY RIDGE LANE, LEAGUE CITY, TX 77573</DESCRIPTION>
<NOTES/>
<PROPERTYNOTES/>
<LEGALTYPE>A</LEGALTYPE>
<SESSIONID>0</SESSIONID>
</ADDRESSLEGAL>
</LEGALDETAILS>
<FEES/>
<ASSOCIATEDDOCUMENTS>
<ASSOCIATEDDOCUMENT>
<ID>0</ID>
<NAME>2007044874</NAME>
<DOCSTATE/>
<RECORDEDDATETIME/>
<TYPE>
<DOCUMENTTYPE>
<ID>0</ID>
<CODE/>
<NAME>RELEASE</NAME>
<SESSIONID>0</SESSIONID>
</DOCUMENTTYPE>
</TYPE>
<PARTY1/>
<ERLEVEL/>
<SOURCE/>
<PARTY2/>
<NUMBEROFPAGES>0</NUMBEROFPAGES>
<SESSIONID>0</SESSIONID>
</ASSOCIATEDDOCUMENT>
</ASSOCIATEDDOCUMENTS>
<ID>834</ID>
<NAME>2014048700</NAME>
<DOCSTATE>A</DOCSTATE>
<RECORDEDDATETIME>8/27/2014 12:07:11 PM</RECORDEDDATETIME>
<TYPE>
<DOCUMENTTYPE>
<ID>577</ID>
<CODE>RELEASE</CODE>
<NAME>RELEASE</NAME>
<SESSIONID>0</SESSIONID>
</DOCUMENTTYPE>
</TYPE>
<PARTY1>MORTGAGE ELECTRONIC REGISTRATION SYSTEM</PARTY1>
<ERLEVEL/>
<SOURCE/>
<PARTY2>GATES, DANIEL</PARTY2>
<NUMBEROFPAGES>3</NUMBEROFPAGES>
<SESSIONID>0</SESSIONID>
</DOCUMENTDETAIL>
</DOCUMENTS></SEARCHREQUESTRESULT>'
INSERT INTO [dbo].[XML_Convert]
SELECT @Text
SELECT
Kachunk.query('(/SEARCHREQUESTRESULT/DOCUMENTS/DOCUMENTDETAIL/ASSOCIATEDDOCUMENTS/ASSOCIATEDDOCUMENT/NAME)[1]')
FROM
[dbo].[XML_Convert]