Hi Ryan,

the following example shows how to take values from a namespace.

declare

@x xml

set

@x = '

<ns0:root xmlns:ns0="http://schemas.microsoft.com/sqlserver/2004/

07/adventure-works/ProductModelManuInstructionsModified">

<ns0:Location LocationID="100"...

Phil,

What exactly is the problem?

do you have a problem to read values from the XML column? if yes, i can help you out.

thankx

Jacob

do you still have a problem?

I am glad to know that the information was helpful. There are a few more posts scheduled and will appear in the coming weeks. So keep a watch 🙂

This sample works on the "subscription" table. It takes the first row and breaks the parameters into two columns.

"parameters" is NTEXT so I cast it to XML with:

SELECT...

The following code generates a resultset with two columns. (name and value).

declare

@x xml

set @x = '<ParameterValues>

<ParameterValue>

<Name>PATH</Name>

<Value>\\srvr01\reports</Value>

</ParameterValue>

<ParameterValue>

<Name>FILENAME</Name>

<Value>Client...

Thank you everyone for reading the article and participating the discussion. A lot of great ideas were discussed in the forum and I am pretty sure that the ideas must...

Hi Neil,

I see that @sqlStr is a TSQL statement. So I am wondering why you execute it using xp_cmdshell.

Very helpful information!

Thank you vincent.

This is quite intersting!

Took 8 seconds on my laptop running SQL Server Express edition.

(Toshiba Satellite Pro, 1 GB RAM, single processor)

- Jacob

Hi jeff,

I have taken your comment in the CORRECT sense only. It was really valuable and I see that the approach you suggested is better. I would welcome your comments in...

Hi Jeff,

I agree with you. You won 🙂

Jacob

Hi Jeff,

Thanks for sharing your code. This is indeed a nice approach.

If you look at my last example, I had said 2.45 minutes for 5 million rows, which also...

Do you have an example that shows your specific problem? I will try to help you out then.