While I have not seen the error, I can't think of a situation where OPENQUERY would help your get out of an error during an Insert, unless it had something...

Agreed - it's not that the counters are wrong - it's that things change about how to interpret them.

Usually with a SAN you end up having to take into account...

I had noticed "The Thread" doing that as well. I just hadn't seen any others.....

you need to build the ENTIRE statement (the openquery itself AND the query that uses the openquery) as a string and then execute that as dynamic SQL.

this is often a matter of how you use what you get back, rather that what is being returned from the stored procedure. I've returned results that are substantially...

Inner JOIN is permutative, so there really is no difference between the 2.

The engine makes its own determination what the "base" table is, so it really doesn't matter which you...

What Lynn and Elliott said...:)

The statements mean different things when you are dealing with outer joins. You won't get the same records.

For example:

select *

from TableA

...

...which is why once you get to 2005 or above, the only thing you should be using is the...

rjv_rnjn (8/25/2009)

---

I do not prefer IDENT_CURRENT as it may give you wrong results (as it's on table across scope). The scenario I fear is a peak load time when 50...

With the amount of info you're giving us, it's fairly hard to tell. What is it you're trying to do?

You could use a modified version of Jeff Moden's "running total" solution to carry the value around. In high cardinality sets - it should outpace the correlated subquery rather...

Take a look at this article. It should help you write this with on "single row updates" going on.

http://www.sqlservercentral.com/Forums/FindPost449802.aspx

Let's just say - time to kick the training wheels off...

It sounds like your XML has a self-describing section. In other words - there's a section explaining the data layout, and one for the data itself.

In most cases you...

Lynn Pettis (8/24/2009)

---

Yes, you are permitted to yell. I'm glad we were able to help you find the problem. Sometimes it just takes another set of eyes. ...