SQL Server Rocks!
  • Home
  • Me
  • ado.sql ltd
  • Contact
  • Ancestry
  • Search

Flwor

A collection of 6 posts

XQuery

Update duplicate xml attribute values to unique value

I was going through some really old blogging ideas and I stumbled over this one and seeing as I love finding creative solutions in XQuery, I'm not sure why I hadn't got this

  • Arthur Olcot
4 min read
Xml

XQuery - Accessing the Attributes Axis

Working with a sequence of attributes in XQuery is fairly straight forward with the 'attribute' axis even if you don't know or need to know the attribute names. By using this axis you

  • Arthur Olcot
2 min read
Xml

Removing HTML formatting tag - BR - from XML using XQuery

This is a personal pet hate of mine.. Mixing HTML formatting tags directly with XML that aren't escaped or contained within a CDATA section. Sure it is all perfectly valid XML at the

  • Arthur Olcot
3 min read
Xml

Retrieving the next or previous element node value in an Xml blob using XQuery

It's been a little while since I wrote a blog post on my favourite subject but this is from a thread on the SSC Xml forum that I was helping out on a

  • Arthur Olcot
5 min read
Xml

Using XQuery to remove duplicate values or duplicate nodes from an xml instance

Sometimes we need to retrieve a list distinct values from within an xml instance or even distinct nodes and this is relatively straight forward using XQuery. It gets a bit more complicated if

  • Arthur Olcot
6 min read
Xml

Using XQuery to transform multiple xml nodes to a single xml node with comma separated string value

Not another comma separated string blog post I hear you say! I know that this topic has probably been done to death but I hope that this is a little different as it

  • Arthur Olcot
2 min read
SQL Server Rocks! © 2021
Latest Posts Twitter Ghost