Posted by rhaazy on 08/28/06 16:44

The problem with this is that there is no upper and lower, the number
or depth if you will of orgnodes is limitless... This is what my major
problem is, figuring out how to get this sort of format (i was giving
more less a psuedo definition of what I need) when say for example
M-Sales gets has a child added to it via the database admin.
> > Hopefully this format is possible...
>
> It does not seem to be. When I look at the examples for FOR XML EXPLICIT
> and FOR XML PATH, they don't lead to that result. And indeed the XML
> document above is sort of funny. A more normal document would be:
>
>
> <ROOT>
> <OrgSystem Name="USA">
> <UpperOrgNode Name="Manistique">
> <LowerOrdNode Name="M-Sales"/>
> <LowerOrdNode Name="M-IT"/>
> </UpperOrgNode>
>
> etc.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Installation of local database
• Prev in forum: Re: Checking if DB Connection is active or not
• Thread view: Re: Help me with this query please.

[Reply to this message]