I am struggling to read the nodes on the following feed using t-sql in SQL Server 2005:
I download it using ASP and then run the following:
DECLARE @docHandle int
DECLARE @xmlFeed XML
SELECT @xmlFeed = BulkColumn FROM OPENROWSET(BULK 'C:\Inetpub\ SINGLE_BLOB) AS x
EXEC sp_xml_preparedocument @docHandle OUTPUT, @xmlFeed
SELECT * FROM OPENXML(@docHandle, 'item', 3) WITH (link VARCHAR(250) 'link/.', title VARCHAR(250) 'title/.')
I think it's something to do with the format of the feed but I'm not sure what or how to get around it. Any help would be much appreciated.
I download it using ASP and then run the following:
DECLARE @docHandle int
DECLARE @xmlFeed XML
SELECT @xmlFeed = BulkColumn FROM OPENROWSET(BULK 'C:\Inetpub\ SINGLE_BLOB) AS x
EXEC sp_xml_preparedocument @docHandle OUTPUT, @xmlFeed
SELECT * FROM OPENXML(@docHandle, 'item', 3) WITH (link VARCHAR(250) 'link/.', title VARCHAR(250) 'title/.')
I think it's something to do with the format of the feed but I'm not sure what or how to get around it. Any help would be much appreciated.