home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 19,319 of 19,505   
   chris to All   
   Re: Unable to query xml data in sql serv   
   14 Jul 20 09:56:45   
   
   From: chris.sjpd@gmail.com   
      
   Hi Erland,   
      
   I need to query out the XML data in a table 's column with XML datatype. The   
   "select xmldata from xmltbl where ..." statement will return several rows.    
   Currently I can get the xmldata if the SELECT statement returns a single row,   
   but the SELECT    
   statement always returns multiple rows.  My goal is to get the result set of   
   XML data in all of these rows at one.  Please let me know how I can achieve it.   
      
   Please keep in mind that all of these rows have to same structure, except the   
   data.   
      
   Thank you & sincerely appreciate your help,   
   Chris   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca