Anaemelerma
New Member
I have a table in SQL server database and I am generating an XML from the table using this query.\[code\]SELECT OrderNumber, CustomerID, ITEMFROM OrderHeaderFOR XML RAW('Order'), ELEMENTS, ROOT('Orders')\[/code\]I get an XML like this:\[code\]<Orders><Order> <OrderNumber>SO101</OrderNumber> <CustomerID>1</CustomerID> <Item>item 1</Item></Order><Order> <OrderNumber>SO102</OrderNumber> <CustomerID>1</CustomerID> <Item>item 2</Item></Order></Orders>\[/code\]But I need to generate the XML in the below format.\[code\]<Orders><Order OrderNumber= 'SO101'> <CustomerID>1</CustomerID> <Item>item 1</Item></Order> <Order OrderNumber= 'SO102'> <CustomerID>1</CustomerID> <Item>item 2</Item></Order></Orders>\[/code\]i.e. the Order number column needs to be displayed as an attribute of the Order Node.How can I achieve this?