Oops! Triple post...

I'll have to go back through my e-mails to find the link to that story, but in my 30 years of IT experience, I've heard a number of anti-database arguments,...

Again, it depends. Are you planning on running those stored procedures from within Access? I haven't tried migrating a query to a stored procedure as yet...

What the previous poster says is not entirely accurate. The answer is, it depends. In many cases, an Access query will need some level of modification...

I took one through TEK Systems, and I was quite pleased with my results, but you definitely can plan on a test not that different from the Microsoft tests -...

I'd agree but for the "human factor". Often, people have to deal with these numbers regularly, and a lack of "organization" of those numbers can be a genuine...

Here's the BOL entry on SET TRANSACTION ISOLATION LEVEL:

"SERIALIZABLE

Specifies the following:

Statements cannot read data that has been modified but not yet committed by other transactions.

No other transactions can modify data...

Yeah, I hear ya... they aren't worried. It's because that's what they pay you for. It may well be a scenario they won't run into for...

Please re-examine my previous post - numerous edits... thx.

Steve

(aka smunson)

:-):-):-)

I'm wondering if you could just have a minimum size for any given range, and pre-populate a table with NULL range id's, that has all the possible ranges of that...

UPDATE:

The "OR" version of the query took 3 mins, 48.383 seconds. Way too long to be able to support any kind of website that might use this...

Unemployment is a tad too common these days. Anyway, the idea of an execution plan doing the "lie like a rug" thing has already been put to bed....

On the "need for speed", that was more of a wish thing... I have an expensive system, and I have expectations for it - realistic in some...

Would you believe that it's entirely a learning process? I'm trying out things, finding out what kind of stuff happens when you have a huge database, and finding...

UPDATE:

Well, actually, my last query wasn't quite right. I just realized that only checking ZIP1 provides only those zip codes larger than than the one being checked,...