Generating self-closing XML tags for lists in SQL Server...

How to put an attribute on the root element, and only the root element, in FOR XML PATH?...

SQL SERVER Select Distinct ID is not working...

TSQL: Return elements of a group as XML...

Cross apply function returning XML needs a column name...

For xml path returns null instead of nothing...

SQL Server 2014 - FOR XML AUTO avoid automatic node nesting...

SQL Server SELECT FOR XML How to get two elements at the same level...

Using FOR XML PATH to output Multiple Sibling Elements...

Subquery in FROM clause is causing unwanted ELEMENT in FOR XML AUTO output...

Different values returned by SQL Server 2000 and SQL Server 2014 when returning results using for xm...

How to output raw xml within an XML projection in SQL Server without introducing an extra xml root e...

FOR XML SQL Server - Variable Element name in output XML...

Select for xml statement to produce excel sheetData format...

Specific XML layout needed...