Thanks Siddarth!

It is a very interesting article.

Is it what you are looking for?

SELECT (

SELECT XML1, XML2

FROM table1

FOR XML PATH(''), TYPE

).query('/*/Response')

/*

<Response>

<Value>Idaho</Value>

<Result>ID</Result>

<Return>50</Return>

</Response>

<Response>

<Value>Texas</Value>

<Result>TX</Result>

<Return>50</Return>

</Response>

*/

I would recommend reading this article that demonstrates how to iterate over the elements of an XML document. http://www.sqlservercentral.com/articles/XML/62290/%5B/url%5D

The XQuery function "local-name()" can be used to find out the name...

This was a problem originally posted in one of the SQL server forums. That gives me an indication that there may be places when this type of queries are used.

Some...

The formatting problem is corrected.

I see that too, and even in IE and firefox. I have sent an email to Steve requesting to take a look at it.

Glad to know it helped. If you are coming for PASS 2009 summit, do let me know and you can grab a copy of my XSD book 🙂

Try modifying the schema and setting "minOccurs" attribute of the element to "0" to indicate that the element is optional. That might help.

The part I have questions are when you update a row at the table level the article says the old file would still be preserved. Whether later it is garbage...

Hi Vikas,

I did not get a chance to work on this. I will let you know If I could find a better way of doing this.

I suppose some of...

I would suggest you login to SQL Server using your Windows account (administrator) rather than using 'sa' (sql server authentication) and try again.

When using FILESTREAM in a clustering environment, you should always create the FILESTREAM file group on a shared disk volume. Is this true in your environment?

Douglas,

Here is the correct link http://blog.beyondrelational.com/2008/09/find-dependent-objects-recursively.html

Thanks

Jacob

Well, I would suggest using some other tools such as SSIS if you want to modify the file.

You can load the content of an XML file to an XML variable using OPENROWSET(BULK..). Once the content of the XML file is loaded into the XML variable, you can...