Hi All,
I am wondering if there is a way for SQL to add attributes into the elements of the results that I return. I.E
SELECT transname,
transfer
from transferee TranNode
XML AUTO, ELEMENTS
I want my XML to look like this
<TranNode>
<transname>MyName</transname>
<transfer transprocess="true">MyTransfer</transfer>
<TranNode>
I would like someway to add the "transprocess" attribute in SQL and not in the DOM doc. Any help will be very very much appreciated.
Carl
¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°¤º°`°º¤ø¤º°¤º°
Carl Evans
CEO & President
System Answers Consulting, Inc.
MCSD .NET, ASP.NET, C#.NET, VB.NET,