From: esquel@sommarskog.se   
      
   > Sorry that your knowledge is a million feet above the ground but mine is   
   > on the other end :-(   
   >   
   > I think about your suggestion but still can't figure out how my cursor &   
   > the rest of the codes work.....   
      
      
   There are two things:   
      
   1) Iterate over the XML files and load them into a table. That is probably   
   better done outside SQL Server using SSIS or whatever you fancy. SQL Server   
   is not the best tool to iterate over a bunch of files in the file system. Or   
   more directly: it is not designed for this and it is awfully akward.   
      
   2) One you have the data in the table, you do as I suggested. The same   
   pattern appears in the StackOverflow post you referred to. Did you actually   
   try it? Note that the data type of the column in your table should be xml -   
   that makes things a little easier.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)