How are you executing this stored procedure? i.e. a job or manually? What happens if you run the commands individually in SSMS outside of the sp? It sounds like...

Can you list what your current settings are for the server options on that linked server?

Thanks,

Jared

GSquared (11/23/2011)

---

p-nut (11/22/2011)

---

GSquared (11/22/2011)

---

It won't catch an iteration from 09 to 10 in the last two digits. If you want that, you need to just modify the Left() and...

I can't wait!

Jared

Check this out:...

Maybe the simplest suggestion for cleanliness and readability is a cte assuming this is a simple aggregate:

;WITH cte (SalesOrderID, ProductID) AS

(SELECT SalesOrderID, MAX(ProductID) AS ProductID ...

Alexander Suprun (11/22/2011)

---

p-nut (11/22/2011)

---

Alexander Suprun (11/21/2011)

---

From my experience using CROSS APPLY will force the server to do LOOP JOIN which may...

GSquared (11/22/2011)

---

It won't catch an iteration from 09 to 10 in the last two digits. If you want that, you need to just modify the Left() and Right() function...

I'm wondering if we are over thinking this a bit.... What about using "quirky update" to determine the mathematical difference between phone numbers in each row and then look for...

Alexander Suprun (11/21/2011)

---

From my experience using CROSS APPLY will force the server to do LOOP JOIN which may be not the...

This is probably a good case for CROSS APPLY

http://weblogs.sqlteam.com/jeffs/archive/2007/10/18/sql-server-cross-apply.aspx

Jared

GSquared (11/21/2011)

---

In that case, I'd start looking into using snapshots for the reports to operate off of. You're almost certainly on Enterprise Edition, which means that's a real option...

Steve Malley (11/18/2011)

---

I thought this was it:

OPENROWSET

( { 'provider_name' , { 'datasource' ; 'user_id' ; 'password'

| 'provider_string' }

,...

GSquared (11/18/2011)

---

p-nut (11/17/2011)

---

GSquared (11/17/2011)

---

p-nut (11/17/2011)

---

Ok, as it turns out she believes the reason is 2-fold. Her words: The first is that the nature of our data does not leave...

agiangone (11/17/2011)

---

Ninja's_RGR'us (11/17/2011)

---

My view of index hints is simply that to use it you must somehow think that you're smarter than all the guys at ms combined and all the...