No need to be concerned:

1.) I don't play poker for millions of reasons: and every one of those reasons has to do with losing money.

For the same reasons, you...

And my response, entirely dead-pan... Oh well... such are the limitations of the written word...

Steve

(aka smunson)

:-):-):-)

Remember when I referred to being "almost despicably anal" about describing EXACTLY what you did ? You've done quite a number of things, but while you say...

To which, the only possible answer is to take that which appears in your current signature...

The quality of the answer is directly proportional...

Another best practice to add to your list: the liberal use of views and/or stored procedures, so as to isolate your application code from the database details. ...

Well, unlike Barry, I won't reply the way he might, such as "Dang, so much for that idea...", and yes, it's for SQL work. However, perhaps I...

When you do performance testing like that, it helps tremendously to clear the cache in advance of each test run, so that cacheing has no impact on the test results....

I'm available nights & weekends at the moment... at reasonable rates.

Steve

(aka smunson)

:-):-):-)

Let's also get a CREATE TABLE statement for each of the tables involved here, so there's at least some way to test. How about it, dcfreefall01 ?

Steve

(aka smunson)

:-):-):-)

How about we at least see this in more readable form:

SELECT jn.branch_no as [Branch #],

b.branch_name as [Branch Name],

Case

...

RBarryYoung,

I suspect you've been away from MLM / network marketing for a while. It's now quite common for the latest and greatest thing since sliced bread to be...

Oh yeah, I almost forgot. Why store an empty e-mail address field? The ideal design is to have a primary key in your resume table, which...

If the only contents of the Email fields are e-mail addresses, then by all means, change the number downwards, but to 100 chars, to allow for some growth (if you...

While you're at it, you might want to post the execution plan for the query that was going to run a while, so we can see where the cost is...

Wow... 1000 characters for an e-mail address, and up to 10 of them ??? Obviously, from your previous posts, these are keyword fields, but I have to...