Convert XML PATH to XML EXPLICIT for SQL 2000

Question

Hi,

I have a section of code that runs on a SQL 2005 server as:

SELECT e.[ElementName] , ISNULL(ElementValue, ElementDefaultValue) AS Value FROM [cx_Element] e WITH ( NOLOCK ) LEFT JOIN [cx_ReportStyleElements] rse WITH ( NOLOCK ) ON rse.[ElementId] = e. [ElementId] AND rse.[ReportStyleId] = 1 FOR XML PATH('')

that results in output like

 <ElementName>ContractLogoUNC1</ElementName>
 <Value>logo-ssw.gif</Value>
 <ElementName>ContractLogoUNC2</ElementName>
 <Value></Value>
 <ElementName>Header_Report_Title_Font</ElementName>
 <Value>Tahoma</Value>

but I need to achieve the same on a SQL 2000 server .... so I have to use XML EXPLICIT ..?

So far I cant get the ElementName tag to format properly or get the Value tag at all.

Any suggestions greatly appreciated

Jonathan

Answer 1

Plz help m also having same problem