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