>>> 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: