Justin 17041 (1/19/2011)

---

But i only need the orders that are Pending Processing or New.. Ive been at this for two days and i cant figure it out would i have...

hxkresl (1/19/2011)

---

For the record, this is not my :crazy: design, but I was trying to make what is, work. The actual solution still eludes me, as it will have...

Keith Langmead (1/19/2011)

---

I've seen lots of comments from people on here and elsewhere about the benefits of blogging, both in terms of focusing and improving your knowledge on certain subjects,...

Correct. While it's intuitive to end users (and most DBAs), it causes no end of problems. For some examples, take a look around the net for "WHERE ISNUMERIC(<somefield>)...

Ferguson,

Just to be upfront: I have nil interest in working anywhere that discusses freezing weather as a common occurrence during any portion of the year (I live in AZ), but...

😀 No, I just happened to be around at that point. You're welcome. This...

hxkresl (1/18/2011)

---

To be able to control the datatypes available for the STAT_VALUE column depending on the STAT_ID/STAT_NAME that it is being populated for.

Is this the slightest bit possible?????! Thanks...

Any chance you can drop an inline table value function on the foreign server? Even if it's in another database so it wouldn't have to cross-server communicate? If...

Gyeah, okay, so you've got...

Eric Russell 13013 (1/18/2011)

---

Craig Farrell (1/18/2011)

---

...

Without anyone usually having the holistic view of everything occuring with any piece of data, we're spiraling out of intelligent data access control. We...

Well now, that's intriguing. It's ignoring the join logic and simply sending the where clause, but it's splitting the where clause to the two foreign tables and doing two...

Hey guys, I'm trying to help magoo out and we're twisting around a non-materialized view, a collation, and a linked server finally giving up on an index seek once transferred...

mister.magoo (1/18/2011)

---

Craig, if I put the WHERE clause inside the VIEW then

SELECT * from vw_test

Works just fine.

Do you think the collation difference could be the cause and do you...

Ah, my brain coughed up something from the bottom of my soul and... oh, wait, I may have just remembered it.

I can't get to skydrive, cause it's blocked from work...

Something else that came up during the Wikileaks bit was the idea of volume confidentiality differences, which is becoming a more severe issue only in recent years.

To simplify the problem:...