>> Do me a favor, try opening the XML file in Internet Explorer. What result
>> do you get?
>>
>> "Dee" discussions.microsoft.com> wrote in message
>> news:73260B01-419E-4E93-9D56-488BEEE88ADB@microsoft.com...

>>>I have tried the following and only get one column in the database and it
>>>can
>>> not be read. It seems as if nothing is in it and it takes a long time to
>>> open.
>>>
>>> DECLARE @xml XML;
>>> use yahoostore
>>> CREATE TABLE Products(xmlCol XML)
>>> INSERT Products
>>>
>>> SELECT
>>> -- @xml = BulkColumn
>>> CONVERT(XML, BulkColumn, 2)
>>> FROM OPENROWSET (BULK 'C:\database\xmldtd\yahoostore.xml', SINGLE_BLOB)xyz
>>>
>>> Do you have any suggestions?
>>>
>>> Thank you
>>> Dee
>>>
>>>
>>>
>>> "Dee" wrote:
>>>

>>>> Mike this is what I am getting in the table:
>>>> USE [yahoostore]
>>>> GO
>>>> /****** Object: Table [dbo].[Products] Script Date: 01/21/2008
>>>> 13:54:11
>>>> ******/
>>>> SET ANSI_NULLS ON
>>>> GO
>>>> SET QUOTED_IDENTIFIER ON
>>>> GO
>>>> CREATE TABLE [dbo].[Products](
>>>> [xmlCol] [xml] NULL
>>>> ) ON [PRIMARY]
>>>>
>>>> Thanks
>>>> Dee
>>>>
>>>>
>>>> "Dee" wrote:
>>>>

>>>>> I never did get
>>>>>
>>>>> FROM @xml.nodes('/Products/Product') Products (x);
>>>>>
>>>>> to work. I am reading and trying. What is the xyz?
>>>>>
>>>>> So far I am getting nothing to work and errors message and I try to
>>>>> find out
>>>>> what they are and try what ever I can.
>>>>>
>>>>> Thanks
>>>>> Dee
>>>>>
>>>>>
>>>>>
>>>>> "Mike C#" wrote:
>>>>>

>>>>>> I assume, since you moved on to the next step of adding the INSERT,
>>>>>> that you
>>>>>> got the shred working properly with no errors. By "directory" I
>>>>>> assume you
>>>>>> mean "table". SQL Server provides only very limited support for DTDs.
>>>>>> Try
>>>>>> giving OPENXML a correlation name:
>>>>>>
>>>>>> SELECT CONVERT(XML, BulkColumn, 2)
>>>>>> FROM OPENROWSET (BULK 'C:\database\xmldtd\yahoostore.xml',
>>>>>> SINGLE_BLOB) xyz
>>>>>>
>>>>>>
>>>>>>
>>>>>> "Dee" discussions.microsoft.com> wrote in message
>>>>>> news:A87085E2-821A-4CC7-B17A-8FBBAD707C26@microsoft.com...

>>>>>>> Mike,
>>>>>>>
>>>>>>> I got the following message with that:
>>>>>>>
>>>>>>> Msg 2389, Level 16, State 1, Line 8
>>>>>>> XQuery [value()]: 'value()' requires a singleton (or empty
>>>>>>> sequence),
>>>>>>> found
>>>>>>> operand of type 'xdt:untypedAtomic *'
>>>>>>>
>>>>>>>
>>>>>>> I also tried using this because my xml file has dtd in it, hence
>>>>>>> the
>>>>>>> directory xmldtd:
>>>>>>>
>>>>>>> DECLARE @xml XML;
>>>>>>> CREATE TABLE Products(xmlCol XML)
>>>>>>> INSERT Products
>>>>>>>
>>>>>>> SELECT
>>>>>>> -- @xml = BulkColumn
>>>>>>> CONVERT(XML, BulkColumn, 2)
>>>>>>> FROM OPENROWSET (BULK 'C:\database\xmldtd\yahoostore.xml',
>>>>>>> SINGLE_BLOB)
>>>>>>>
>>>>>>> Product
>>>>>>>
>>>>>>> SELECT * FROM Product
>>>>>>>
>>>>>>>
>>>>>>> It create a directory named produdcts, but the only column was an
>>>>>>> xml
>>>>>>> column
>>>>>>> with nothing in it.
>>>>>>>
>>>>>>> Dee
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> "Dee" wrote:
>>>>>>>

>>>>>>>> Sorry to keep posting, but I do look these up first, just not
>>>>>>>> getting the
>>>>>>>> correct error of what I need to change.
>>>>>>>>
>>>>>>>> I am now getting:
>>>>>>>>
>>>>>>>> Msg 318, Level 15, State 0, Line 42
>>>>>>>> The table (and its columns) returned by a table-valued method need
>>>>>>>> to be
>>>>>>>> aliased.
>>>>>>>>
>>>>>>>> Also will this insert the data from the xml file into the
>>>>>>>> database?
>>>>>>>>
>>>>>>>> Thank you and I am trying to find these things out as I go.
>>>>>>>> Dee
>>>>>>>>
>>>>>>>> "Mike C#" wrote: