Hi,

The XML string is not properly displaying on my previous post. If you would like full example, just send me an email.

Thanks,

Argneka

Hi,

Here is a simple example of how I implement XML in sql2005:

declare @XmlList XML

Declare @Property varchar(50)

Declare @ObjectName varchar(50)

Declare @ColumnName varchar(50)

Declare @Value varchar(50)

Declare @rowcount int

Declare @count int

Declare @XmlCount int

set @Count=1

select @XmlList=

...

Hi,

Yes I am aware of this. Unfortunatly I am using SQL2K and SQL2005. My soultion does work well for it's intended use. Not Ideal for huge amounts...

Hi,

This does exacally what I wanted it to do. Thanks for the insight. I have alot more work to do but the core is 100%.

declare @XmlList XML

declare @count...

Hi again,

I have it working, but I could not figure this part out. Query Analyzer throws an exception for XQUERY on this line of code:

SELECT

@max-2 =...

Hi,

Yes that may work. I was able to pass as a XML values as attributes. Then I just used a CURSOR - I know performance hog and this...

Thank you

Hi,

Yes, I agree with parsing large amounts of data. In this case I have a datable in my C# app that I want to pass as an XML parameter....

Hi,

Hold the Bus. I think I figured it out. I will sed you an update when I am done to see if there is a better way to...

Hi,

How would I iterate through an XML object to obtain each specific row 1 at a time. I was trying this way, but value requires a literal for both...