I guess the main problem with shredding the XML,...

Id love too, can you point me in the...

Edit2: OOps my understanding of it was incorrect, indeed it convers XML to nvarchar, and that is not large enough to contain the entire XML string.

SO, back to the drawing...

Thank you!

it works, right out of the box.

I don't know why I didn't think of this.

I guess I got caught up in the fact that it was XML.

Hi

thanks for both your replies.

@mmartin1 I figured out why that doesnt work, its because my tablename is not a tag/component, but part of a string that is located...

I don't understand this.

Using the above example, I changed it to the following:

[Code]

DECLARE @tbl TABLE

(

id INT,

col XML

)

INSERT INTO @tbl

VALUES

(1,'<name><name1>aht</name1></name>'),(2,'<name>6</name>')

DECLARE @id VARCHAR(10)

SELECT @id = 'aht'

SELECT...

Hello Adam.

First thanks for some awesome articles. I don't have a2012 in hand, but I'd like your comment on the performance for these dynamic reports.

Given 3 years of...