Yeah that's a 5-star article that I only wish someone had written 3 years ago. I am so tired of hearing the "Number of Tempdb files" argument everywhere I...

This sounds like either DST or TimeZone adjustments by the asp code.

Nope, sorry, I got mixed up (long time since I used it), InStr(..) is the VB/Access version of Charindex() (there used to be another version called Loc() also).

InStr() is an alternate version of Mid(), sort of like Substring().

Glad I could help.

The arithmetic and logical expressions to do this are pretty easy (it's "Power(..)", "|" and "+" mostly), however, what not clear is where the multiple bits are coming from in...

If you are on SQL Server 2005 or 2008, you should not need multiple Tempdb data files unless you are observering latch contention on your temp table cache. If...

Try it like this:

update a

set a.allocation = b.esol

from lcp.dbo.working_table b inner join linked_server.lcp.dbo.rpt_allocationdata a on

b.usd = a.org_no

where a.code...

They will probably need the "SQLAgentOperatorRole" fixed database role in the [msdb] database.

So, what was it? You never know when someone else might have the same problem.

mrlucmorin (5/12/2009)

---

Hi,

Thanks both for the quick reply.

I guess that internally, the server "knows" which rows of TableA are included in the JOIN, though what I'd like to know is how...

Gaby Abed (5/12/2009)

---

Bob Hovious (5/12/2009)

---

I'm inspired!! Imagine a banjo....

Ohhhhhhhhhhhh

I call up Engineering... holler "Gimme warp three"

I got a half a billion Klingons all as pissed as they can...

You will note for instance that the 2005 EXCEPT and INTERSECT operators both compare all column values to determine the matched and unmatched rows (which is what makes them nice...

Lamprey13 (5/12/2009)

---

WebTechie38 (5/12/2009)

---

You know I've met some great people on this forum and some I truly look up to as mentors.

Then there are times people post things and you are...

Maybe, but I don't think it's a database problem, per se, but rather some disconnect between how the database is setup vs., what the app thinks that it should be....