Top "For-xml-path" questions

"FOR XML PATH" is a SQL Server query directive to return the rowset as an XML document using "PATH" mode.

How to avoid namespace in child nodes using FOR XML PATH?

I want to create a sitemap xml file (including images) directly from the database without another process (like transformation or …

Read More
tsql namespaces for-xml-path
SQL Server : Group by string concatenation

I have a question. I know that has been asked before. I looked through the related questions but I could …

Read More
sql-server group-by concatenation for-xml-path
Converting MSSQL 'FOR XML PATH' To Oracle

I have a Statement to fill a table on my MSSQL Database. It joins some values together seperated by a …

Read More
sql sql-server oracle code-conversion for-xml-path
SQL FOR XML PATH list and COUNT

I have a table such as: |Date |Name| -------------------- |'20-May-2011'|Bob | |'20-May-2011'|Fred| |'20-May-2011'|…

Read More
sql-server for-xml-path
TSQL: FOR XML PATH('') Failing To Group

I'm trying to group column values by a specific column using FOR XML PATH('') in TSQL. This is the …

Read More
tsql sql-server-2008-r2 for-xml-path
What is the equivalent of XML PATH and Stuff in Linq lambda expression (GROUP_CONCAT/STRING_AGG)?

I am having a table like this : EmployeeId EmployeeName ItemName 4 Ganesh Key Board 4 Ganesh Processor 1 Jignesh Key Board 1 Jignesh Mouse 1 …

Read More
sql linq lambda substring for-xml-path
How to SELECT DISTINCT with an ORDER BY and FOR XML in SQL Server 2008+

So I have been fighting with this for a while now and I thought this had to be a simple …

Read More
sql distinct for-xml-path