Viewing 15 posts - 3,196 through 3,210 (of 7,631 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 &...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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,...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 26, 2009 at 3:41 pm
dphillips (3/26/2009)
RBarryYoung (3/26/2009)
Have you checked the compatibility level?
Score. 2 points. Thanks for asking... yes, the defaulted DB was in fact creating the table in database that was set to...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 26, 2009 at 3:37 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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 26, 2009 at 3:13 pm
dphillips (3/26/2009)
RBarryYoung (3/26/2009)
Jason Shadonix (3/26/2009)
RBarryYoung (3/26/2009)
ganeshi (3/26/2009)
This works on both SQL 2000 and 2005 and produces answer (c). Please amend the question to be more specific about SQL versions.Ganesh
I have...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 26, 2009 at 3:09 pm
You know, correctly reformulated this could be one heck of a wicked question.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 26, 2009 at 3:02 pm
Jason Shadonix (3/26/2009)
RBarryYoung (3/26/2009)
ganeshi (3/26/2009)
This works on both SQL 2000 and 2005 and produces answer (c). Please amend the question to be more specific about SQL versions.Ganesh
I have tested it...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 26, 2009 at 2:58 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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
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...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 26, 2009 at 2:28 pm
ganeshi (3/26/2009)
This works on both SQL 2000 and 2005 and produces answer (c). Please amend the question to be more specific about SQL versions.Ganesh
I have tested it on SQL Server...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 26, 2009 at 8:29 am
However, you can convert from Text to Varchar(MAX) and from Varchar to XML.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
March 26, 2009 at 8:13 am
Viewing 15 posts - 3,196 through 3,210 (of 7,631 total)