Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-15 : 07:58:51
|
| suryag writes "Can any one help me how to send the result sets to XML when we have two nodes at the same level.(Using FOR XML AUTO in SQL server 2000)For example : Table2 <-- Table1 --> Table3 --> denotes one to Many relations and the output XML tree should be :Table1(reslut set)||____Table2||____Table3....cont the 2 nodes for all recordsYour help is greatly appreciated.Thanks" |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-16 : 00:39:31
|
| Probably best if you post SQL statementsfor CREATE TABLE, INSERT some sample rows and the current SELECT statement you are using, and perhaps an indication of what output you want, so that folk here can try your example. Otherwise each person who wants to answer your question has got to do all of that themselves!Kristen |
 |
|
|
|
|
|
FOR XML AUTO - 2 nodes at same level