Hi, the reason why the xml is changing when you add the additional predicate is because the sub query is only returning a single record (item) for each account rather...

I'm probably not quite understanding what you need to achieve, but if you are looking for an <employeeEntry> based on a known attribute, like the ID or name for example,...

rhythmk (5/22/2014)

---

Thanks for the question Steve.

However I think version of SQL server should be mentioned in question as Remote maintenance plans can not be accessed by Log file Viewer in...

No problem.. thanks for the feedback! 🙂

Sorry, ignore...

In fact, i've just seen your order by clause.. That is why the tag is being moved.

In any case, I generally avoid using EXPLICIT unless i have to generate...

Hi. Yes path mode will give you a lot more control over the attributes and elements. You can specify the path of nodes as part of the column alias. Pretty...

Interesting question. Although I feel that if you need to have line feeds/carriage returns in the dynamic SQL that you are constructing, I find it better to incorporate that into...

Richard Warr (4/7/2014)

---

Despite popular opinion (see above) there's no "easy" answer to this. NOEXEC is good but it won't find everything and there is the risk that you might miss...

Great quality question.. Content (and humour!) aside, the question itself actually made you think and apply logic to come up with the most likely correct answer (which we all have...

The xml is invalid... the closing tag character ("/") goes at the start of the name of the xml element unless it is empty in which can you can put...

Hi.. I would use something like the following. This is checking to see if the text node is empty or not in the predicate.:

set @xdata.modify('delete //step[empty(text())]')

Hi,

You can use the xml methods to shred the xml to a flat table but because the data is stored in a text column, this will need to be casted...

Hi,

If you want to use a stylesheet then your options are going to be limited if you want to keep it all inside sql. SSIS supports xsl transformations via the...

You can extract specific nodes by use the xml values() method. Additionally, because the data that you have is using a namespace, you also in this instance need to declare...