GilaMonster (10/8/2009)

---

SELECT @XML = '<outer>

<inner>

value

</inner>

</outer>'

SELECT @XML = '<outer><inner>value</inner></outer>'

Edit: It's the presence/absence of line breaks. If there's a linebreak anywhere in the code block, the < and > come out correct....

You're welcome.

Gianluca Sartori (10/9/2009)

---

I'm not worried about that, nor I...

Jack Corbett (10/8/2009)

---

GSquared (10/8/2009)

---

According to what he posted, it's using 1.3. That plus the swap file data makes it look like a memory pressure issue to me.

Since we're pretty...

Yes, you can connect with native client. The documentation on it is here http://msdn.microsoft.com/en-us/data/aa937733.aspx.

Native client is a means for getting applications to connect to SQL Server. It's not...

jcrawf02 (10/9/2009)

---

Aside from the rioting that will occur when parts of the Thread no longer make sense ...[pause for effect]

...

...

...

...I don't think any of us really care about generating points...

Gianluca Sartori (10/9/2009)

---

I had a hot discussion with Joe Celko some days ago about the quirky update.

He doesn't seem to like it.

I told him I use the quirky update expecting...

I didn't know if you wanted to have the amount of time it was in the particular state, and, if so, by what interval (minutes, seconds, hours, etc.), so you'll...

Try something like this:

create table #T (

ID int identity primary key,

Time_stamp datetime,

Machine_state int);

insert into #T (Time_stamp, Machine_state)

select '3.27.2009 23:00', 0 union all

select '3.27.2009 23:45', 1 union all

select '3.27.2009 23:55', 2...

select cast('<row A="A" />' as XML)

Very weird! This even runs correctly in SSMS, and I really don't see the difference between it and the prior post. I even...

select col from table where '<xmlstuff />';

Okay, now that's weird! Why does the other XML code work, but this doesn't?

I'm gonna go with, "would have to see the code"....

select col from table where othercol '>' avalue;

It's not the single-quotes around it. Some other variable.

IE version 8.0.6001.18702

select col from table where othercol > avalue;

But when I copy-and-pasted this in, it got FUBARed.

declare @XML XML;

select @XML = '<root>

<column_name>

<node_a>value1</node_a>

<node_b>value2</node_b>

</column_name>

</root>';

select x.y.value('local-name(.)', 'VARCHAR(50)'),

x.y.value('.', 'VARCHAR(50)')

from @XML.nodes('//*') x(y);

And yet, I just posted this in another thread.

When you say you've indexed those columns, do you mean that you have one index on each column, or one index that has all of them?

Can you provide a create...