A million of us?!?!?! There are a million of us??

No wonder the jobs are scarce. Perhaps the answer to the employment problem and the central question of this...

In cases where the OP is unwilling to contribute to his own success, it might be tempting to reply:

OK, if you want me to read your mind, you have to...

Lynn,

I've been following the other thread mentioned above. Based on the expected outcome he just posted (which had exactly 0 relation to the sample data provided), if you choose...

I've done both Oracle and SQL Server and I'll take SQL Server any day. For my money, Oracle is needlessly complex, tool poor, and requires a significantly greater amount...

Yes, while I don't have as many answers as several of the folks here, I swear I want to start some of the replies I do have with:

First you stand...

I can't believe I've missed out on 50 pages of this discussion (especially the beer recommendations (Guinness for daily upkeep, Cave Creek Chili Beer for those times when a hangover...

Well, since you're updating multiple tables, you might just trap the update statements into scripts and run several in parallel. If you're not adding new columns on a regular...

How large is the database?

How often do you backup the logs?

Are there scheduled maintenance jobs running during the slow periods on either the SQL Server or the SAN?

How 'large' are...

This looks like it generates update statements that increment every datetime column in the database by 1 day.

Is that really what you want to do? I'd be curious as...

I'm not sure if I really understood the problem since those update statements looked a little strange, but you may be under the impression that just because you have a...

I'm a little confused. Couldn't you just select CustomerAddressID?

Or try this:

Select CustomerID + '-' + AddressTypeID

I wouldn't recommend a full backup everytime something changes. The "standard" methodology is to take backups of the transaction log at regular intervals between full backups. With the...

This form will let you set more than 1 variable

select @variable1 = column1, @variable2 = column2 from ...

I'm sorry, Access isn't my area of expertise, but can't you type them all in one query window and execute them all serially by just clicking 'execute' on the window?

Or...

You're updating two different objects, so you'll need two update statements.

Why do you need to combine them?

Unless you want all the rows in those two tables to be the values...