Cannot be done with SQL itself. You will have to have a tier to stream the data in.

Ahh comon, at least Office 2007 is more compatible with everyone, as the files are xml based.

Not sure exactly what you mean, but as I understand your question the answer is a view is a stored query, it executes and returns the resultset when called, no...

The are incompatible, you will need to create a database on SQL 2000 an import the data using the Import/Expot process from SQL 2005 instance. But you may not be able...

The structure of an Oralce DMP file is incompatible with SQL Server. You will need either the data exported to CSV or TAB files for importing or have an Oracle...

Not neccessarily, make sure yo include DB and LOG growth. Remember TempDB is a scratch pad for large resultsets as they are bein joined or otherwise manipulated. Most times large...

I would try the index first, an unless either of the two columns are already in the primary key I would make an index with both in it, probably RouteID, ClientNumber...

Plus overcharging as a new DBA for a first time project can lead to blacklisting. I started out at $30 an hour on my first project with a fixed time...

Common issue for these types of things can be the stored execution plan. If you have a query that is based on variabl range size the first execution plan can...

Good point, got on one path and forgot to rethink when I had new information given to me.

And you are right, as a developer I would still say send more details and hash these things out, but posting here I do tend to work under some assumptions...

First do some gerenral maintenance to be sure things are par, depedning on sql version

DBCC INDEXDEFRAG or DBCC DBREINDEX -- to cleanup the indexes

then

sp_updatestats -- to update the databases statistics...

Fo me the issue I hav seen is that it all boils down to user experience. If the user has issues and even after a long period cannot figure out...

Although it may no handle everything you want (as I wrote it a long time ago and haven't doen muh with it) looking at te code shoul help you to...

That is life as it seems. Glad you found your answer thou.