Viewing 15 posts - 3,196 through 3,210 (of 7,636 total)
That's a problem with the xQuery then. I cannot help you with that unless you are willing to post the XML or a least a content-sanitized version (tags &...
March 27, 2009 at 5:23 am
SQLBOT (3/26/2009)
Any advice on where to go next?
What are the individual physical disk's %Idle, before & during?
March 26, 2009 at 10:27 pm
Then this should work:
SELECT CAST(CAST(XMLMessage as VARCHAR(MAX)) AS XML).query('/PatientId/IdValue')
from DocumentSource
March 26, 2009 at 7:41 pm
Jeff Moden (3/26/2009)
RBarryYoung (3/26/2009)
Jeff Moden (3/26/2009)
RBarryYoung (3/26/2009)
"Not working" doesn't tell us very much. Is there an error message?Dang... now I'm disappointed... I was sure that you could read minds... 😛
Well,...
March 26, 2009 at 7:25 pm
Jeff Moden (3/26/2009)
RBarryYoung (3/26/2009)
"Not working" doesn't tell us very much. Is there an error message?Dang... now I'm disappointed... I was sure that you could read minds... 😛
Well, I do have...
March 26, 2009 at 3:41 pm
Thanks for the confirmation, Gus. And yeah, I figured that it was no cheap approach because it requries a lot of hardware, but since it is so spread out...
March 26, 2009 at 3:26 pm
Luke L (3/26/2009)
Chris Morris (3/26/2009)
Grant Fritchey (3/26/2009)
Besides, I've operated nuclear power plants while inebriated (not my fault, my chief liked drinking partners) and nothing happened.
If anybody wants to know...
March 26, 2009 at 3:13 pm
barunpathak (3/26/2009)
Any other suggestions/advise please?
In additiona to what Florian said (which I completely agree with), if my response was not what you were looking for, you should explain why not...
March 26, 2009 at 2:51 pm
I think that you will have to give us the Table definition (CREATE TABLE, please) and tell us what you are trying to do with this query because it is...
March 26, 2009 at 2:28 pm
However, you can convert from Text to Varchar(MAX) and from Varchar to XML.
March 26, 2009 at 8:13 am
Viewing 15 posts - 3,196 through 3,210 (of 7,636 total)