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 |
|
John Sourcer
Yak Posting Veteran
91 Posts |
 Posted - 2009-02-16 : 08:28:56
|
| Hi All, Is it possible to do a FOR XML EXPLICIT query on a single table?I have a table:ID | ParentID | Name1 | 0 | Bob2 | 1 | JamesAnd I am trying to return this as nested XML. I know I can do this if I know how many levels it has, but I don't. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
John Sourcer
Yak Posting Veteran
91 Posts |
Posted - 2009-02-16 : 08:56:34
|
| Thanks as always oh great Yak.I'm using CTE's elsewhere for trees. Just didn't know if you could return the data FOR XML |
 |
|
|
|
|
|
For XML explicit single table