Stuart Ainsworth shares a client case of importing XML documents into a staging table and what he learned about using XQuery methods in SQL Server.
SQL SERVER – Group by Rows and Columns using XML PATH – Efficient Concating Trick
A reader wanted students and courses grouped by course and instructor in a single row. Here is a simple concatenation trick with XML PATH that does it.
STRING_AGG Limits: The 8,000 Byte Error, Ordering and Duplicates
Fix STRING_AGG 8,000-byte limits, enforce ordering, remove duplicates before aggregation, and compare its timing with XML.
SQL SERVER – Grouping by Multiple Columns to Single Column as A String
How do you group data from multiple columns into one comma separated string per row, grouped by another column? Here is a sample dataset and the query.
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
Want to share a graphical execution plan? Save it as a .sqlplan file and send it. Anyone can open it in SSMS without the tables or indexes behind it.
SQLAuthority News – Guest Post – SELECT * FROM XML – Jacob Sebastian
Getting NULL when reading a value from XML? Most of the time the XPath expression is wrong. A guest post by Jacob Sebastian on writing it correctly.