Path: csiph.com!eternal-september.org!feeder.eternal-september.org!reader01.eternal-september.org!.POSTED!not-for-mail
From: Erland Sommarskog <esquel@sommarskog.se>
Newsgroups: comp.databases.ms-sqlserver
Subject: Re: Unable to query xml data in sql server
Date: Sat, 13 Jun 2020 10:36:10 +0200
Organization: Erland Sommarskog
Lines: 8
Message-ID: <XnsABDB6BDB76048Yazorman@127.0.0.1>
References: <b8df0410-a799-45e8-b128-4c8a62b38ed6o@googlegroups.com> <XnsABD8DEF547D6EYazorman@127.0.0.1> <25356606-299b-4623-809d-0d6eb9af0906o@googlegroups.com> <XnsABD8F11BF16BFYazorman@127.0.0.1> <4b1c3504-2511-4c3c-a5fb-b880e39caeb6o@googlegroups.com> <XnsABD928EDA5F3Yazorman@127.0.0.1> <07f4ed04-6ddf-42e8-afac-655b93b690e3o@googlegroups.com> <XnsABD9D6547A1DYazorman@127.0.0.1> <e9abcea1-90f7-4055-8a21-1569c4d6e03ao@googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 8bit
Injection-Info: reader02.eternal-september.org; posting-host="9f2278db4b53c251bcc5d2d7dd45b4f8"; logging-data="27212"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1+6Cp+rF6aZXcDa5lTsoc4V"
User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock: sha1:ayoR/bRSEdO9MipybUJGCnLp+D4=
Xref: csiph.com comp.databases.ms-sqlserver:2051

> Thank you so much for your help.  I'm able to query out some data now. 
> Do you know the best way to query multiple xml files?  All of the files
> have the same file format, except the value. 

SELECT ...
FROM   tbl
CROSS  APPLY tbl.xmlcol.nodes('/agency') AS Agency(A)
CROSS  APPLY etc