Fun with serialization

One of my favorite things to do with SQL Sever is XML. There are just all kinds to idiosyncrasies; however, after spending a substantial amount of time formatting xmlthere where a few things I didn't want to have to find again.