From: esquel@sommarskog.se   
      
   > 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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)