Article is good. But it could have more better with one/ two examples using above commands.

You're cute, but this article tells me nothing about how to use any of these technologies. If you're not going to give some command documentation and examples, at least provides links to places where it can be found, otherwise this article is just one big tease.

You're cute, but this article tells me nothing about how to use any of these technologies. If you're not going to give some command documentation and examples, at least provides links to places where it can be found, otherwise this article is just one big tease.

The Cribsheet was supposed to be a 'helicopter view' of the subject. This was followed by http://www.simple-talk.com/sql/t-sql-programming/xml-jumpstart-workbench/ which has plenty of examples.

I've been searching for an answer for some time and can't seem to find one. When using FOR XML EXPLICIT with two tables & UNION ALL, how do I add a root element in my sproc? As in if I just want to wrap my XML with a foo root element. My procedure is creating multiple root level elements even though I for the most part have the xml formed to my liking. Probably not the best place to ask the question, but I'm here now & you seem to like dealing with XML in sql. cheers

Just in case someone else is looking for an answer to my previous question. Forget about FOR XML EXPLICIT and use something along the lines of the following:

FOR XML PATH('Area'), ROOT('Areas')

Example: http://jdixon.dotnetdevelopersjournal.com/sql_2000s_for_xml_explicit_vs_sql_2005s_for_xml_path.htm

http://www.schule-bewegen.de/moodle/user/view.php?id=61&key=replica-purses

http://chanelhandbags.xja.pl/

http://forum.torrentreactor.net/member.php?u=20363

http://www.dotbb.be/phpbb21/?mforum=replicahandbag

http://www.gametab.com/forums/showthread.php?t=5446

http://www.phetermine.0x.ro/

http://xanex.forumakers.com/

http://themirmont.com/showthread.php?t=7410