Hi I am new to for xml I have a query like this SELECT ProjectId, ProjectCode, ProjectName, TechId, -- LocationId, ( SELECT GeoId,PoliticalDivisionId ,GeographicLocationName,IsoCode,...

I'm trying to use CHAR(13) to force a new line, but the problem is, I'm doing this within a FOR XML Select statement: SELECT STUFF((SELECT CHAR(13) + Comment FROM myTable FOR XML PATH ('')) ...

I have a SQL Server 2005 query that generates a large result set (up to several gigabytes): SELECT * FROM Product FOR XML PATH('Product') Running the query generates a single row containing a do...

I have been working on the T-SQL FOR XML with PATH Mode to create a Hierarchy based on the group by field. Below is my query and output. Pls help me with your valuable suggestions. Thank you. Good ...

I have a stored procedure which uses a FOR XML statement at the end of it, and returns me some XML. I am using .NET 4 and the Entity Framework and when I do a function import of this stored proced...

I have an adjacency list in the DB and want to deliver the data in XML format to the client through a SQL SP. I'm trying to use CTE and FOR XML but I am not getting the XML nodes to nest. FYI, thi...

we have a simple table and need convert to XML Declare @Person TABLE ( [BusinessEntityID] [int] NOT NULL, [PersonType] [varchar](2) NULL, [Title] [varchar](30) NULL, [FirstName] [varchar](30) ...

I'd like to return the below xml: <ResultDetails> <Node1>hello</Node1> <Sites> <Site><SiteId>1</SiteId></Site> <Site><SiteId>2</SiteI...

I'm trying to export some data from a database in a particular XML format specified by the customer. The XML I produce will be manipulated (presumably by XSLT) by a 3rd party to produce the final o...

I have a table with a structure like the following: LocationID AccountNumber long-guid-here 12345 long-guid-here 54321 To pass into another stored procedure, I need the XML to look l...

I have a table with columns NodeId, NodeName, ParentNodeId and I want to ouput entire table data in the form of Xml like the following using SQL query. I think FOR XML PATH mode in Sql server can b...

I have a query like the following: ;WITH XMLNAMESPACES ( DEFAULT 'http://www.somewhere.com') SELECT ( 'SOMETHING' ) FOR XML PATH('RootNode'), TYPE Running this works fine. However, I run into tr...