for-xml-path

SQL Server 2005 select for XML path with union in sub-selection problem

Hi There, I'm rather experienced with SQL server "select for XML path" queries but now i run into a strange problem. The following query works fine: select ( select 'Keyfield1' as "@Name", t1.Keyfield1 as "Value" from MyTable t1 where t1.KeyField1= t2.KeyField1 and t1.KeyField2= t2.KeyField2 for xml...

XML declaration with "FOR XML PATH" in SQL Server 2005

Below is a simplified version of a query that I have already created. The query works fine, but I cannot figure out how to get the XML declaration at the top of the generated XML. I've tried multiple things and searched far and wide on the Google, but alas I cannot seem to find out how to do this ... or even if it is possible. select ...

How to add an attribute to element-centric FOR XML PATH query

I'm building some HTML to be included in the body of an email and sent using sp_send_dbmail. I'd like to right-align some of the columns. Is there an easy way to do this (short of rewriting it using FOR XML EXPLICIT)? declare @html varchar(max) set @html = '<table cellpadding=0 cellspacing=0 border=0>' set @html += cast( (sele...