I figured it out I will post the code.

DECLARE @XmlDocument XML

DECLARE @XmlDocumentID INT

EXECUTE sp_xml_preparedocument @XmlDocumentID OUTPUT, @XmlDocument, '<entry xmlns:x="http://www.w3.org/2005/Atom" xmlns:y="http://ws.constantcontact.com/ns/1.0/"/>'

SELECT [ID], [Link], [LinkRel], [Status]

FROM OPENXML(@XmlDocumentID, 'x:entry', 2)

WITH

(

[ID] NVARCHAR(256) 'x:id',

[Link]...