We aim to please

Both Kofi's and David's suggestions should perform well if you have the tables indexes for those columns. The query optimizer can take some shortcuts and get you quick results.

Can you post some code?

The ideas above are what I thought of. Data should be consistent and usually corruption results in pages being skipped missing data.

Those are definitely good ideas and that's a great book, but in a lot of cases I've worked on projects that couldn't be phased. Usually if that's the case, you...

For a windows alert, you can go into the services applet in control panel. Pick the SQL Server Agent service and get properties. Go to the recoveyr tab. There you...

Ed brings up a great point. Also be sure that you aren't abandoning open transactions with connecitons being held open.

I'm not sure if the .NET state changes anything on the...

It seems the second inner join isn't needed. Collapse this

/*Add the Company name for the lot numbers used in the JO*/

Select qalotc.fclot, qalotc.fcpartno, ct.fccompany

from qalotc

Join

(

...

Or if you don't need the data for other purposes, use Peter's idea, but update, then delete from temp where matching the table, then insert everything else.

I can positively, most definitely state that I am almost 100% confident that we are mostly talking about databases.

I think.

I doubt Access grows. More likely people will shift to VB.NET instead. VFP was a full featured development environment, with lots of OOP built into the product. You could develop...

I think Steve was paraphrasing Fred Brooks: Adding more people to a late project makes it later.

The reasons above are pretty accurate and the classic example is 9 woman cannot...

I use yyyymmdd for filenames. Easier to sort things

I think the dd-mmm-yyyy where mmm is Jan, Feb, etc. makes sense.

As of now, we're...

Yep, I'll add it to the list. This whole section will get some work in the next couple months.

Very strange. Does it hang when scheduled? I'm assuming that's the issue.

Are you sure there's nothing else in the package that would pop a msgbox or wait for some interactive...

It is a nice clue that the author may not be the brightest T-SQL bulb in the pack, however.