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 - 2001-09-24 : 01:16:29
|
| Fernando writes "well, supose i have three tables, customers (clientes), invoices (facturas) and invoices details (detalle). I want SQL Server retrieve data in this format.<Cliente> <nombre>Fernando</nombre> <facturas> <factura nro = 1111> <fecha>10-01-1999</fecha> <detalles> <detalle> <articulo>1012</articulo> <monto>100</monto> </detalle> <detalle> <articulo>102</articulo> <monto>10</monto> </detalle> </detalles> </factura> <factura nro = 1112> <fecha>10-01-2000</fecha> <detalles> <detalle> <articulo>112</articulo> <monto>1343</monto> </detalle> <detalle> <articulo>10002</articulo> <monto>332</monto> </detalle> </detalles> </factura> </facturas></cliente>how should i write my query???thanks a lot" |
|
|
|
|
|
troubles getting data in XML format