One of the most common questions I receive in email is how to group multiple columns data in comma separate values in a single row grouping by another column.
I have previously blogged about it in following two blog posts.
SQL SERVER – Methods for Accessing SQL Server XML Datatype – Quiz – Puzzle – 20 of 31
In this blog post, we will learn about methods for accessing SQL Server XML DataType. Here is an article which discusses the Author’s Perspective.
SQL SERVER – View XML Query Plans in SSMS as Graphical Execution Plan
Earlier I wrote a blog post on SQL SERVER – Parallelism – Row per Processor – Row per Thread, where I mentioned the XML Plan. As a follow up on the blog post, I received the request to send the same execution plan so that the blog readers can also…
Read More
SQLAuthority News – Guest Post – SELECT * FROM XML – Jacob Sebastian
One of the most common problem SQL Server developers face while dealing with XML is related to writing the correct XPath expression to read a specific value from an XML document. I usually get a lot of questions by email, on my blog or in the forums which looks like the following:
SQLAuthority News – Converting a Delimited String of Values into Columns
This blog post is about two great bloggers and their excellent series of blog posts. It was quite unusual to see two bloggers posting articles that are supporting each other and constantly improving the articles to the next level. Two blogs which I am going to mention here are as…
Read MoreSQL SERVER – Comma Separated Values (CSV) from Table Column – Part 2
In my earlier post, I wrote about how one can use XML to convert table to string SQL SERVER – Comma Separated Values (CSV) from Table Column. The same article is also published on channel 9 SQLAuthority News – Featured on Channel 9. One of the very interesting points that…
Read More
SQL SERVER – Validate an XML Document in TSQL using XSD by Jacob Sebastian
Let us learn about XML Document in TSQL using XSD by Jacob Sebastian.