Then you haven't lived until you get a table that has a cross join for all columns in the table as indexes! And the other table has no indexes! This...

1) BEGIN TRANS should be just before the 1st data modification statement

2) The BEGIN ... END is to allow multiple line conditionals so your:

 IF @errorcode = 0

  BEGIN

    ...

I suggest that it will be cleaner if you add the other ID column to the destination table, then perform an Update using the other criteria (you mentioned same last...

Think of GO as a way to combine T-SQL that would otherwise fail due to dependancies. It is also required to denote the end of a CREATE statement, if you...

Check to see if there are open transactions using EM, Kill any long running processes that might be holding your log hostage. You can also use DBCC OPENTRAN('mydatabase') to check...

Just be aware that when you do a MIN or MAX on two columns from the same table, you are probably NOT getting the values from the same row.

Sometimes I...

I am guessing that you are using a linked server for the Excel XLS, right?

Since you stated that the data flow is from SQL Server to Excel, then the XLS...

Since the change from Simple to Full requires a full backup of the DB before the logs can be used, you would also have to perform the backup in this...

EM uses SQL-DMO which always requires refresh for everything, so the answer to your question is:

Whenever you choose the refresh context menu item on the object you want to...

Try:

INSERT masterTable (Name, Phone, CallResult, CallDate, CallTime)

SELECT Name, Phone, CallResult, CallDate, CallTime

FROM stagingTable

 LEFT JOIN(SELECT NULLIF(LTRIM(RTRIM(ISNULL(Name,'')+ISNULL(Phone,'')

   +ISNULL(CallResult,'')+ISNULL(CallDate,'')

   +ISNULL(CallTime,''))),'') AS PK

  FROM stagingTable) AS New

 ON NULLIF(LTRIM(RTRIM(ISNULL(Name,'')+ISNULL(Phone,'')

   +ISNULL(CallResult,'')+ISNULL(CallDate,'')

   +ISNULL(CallTime,''))),'')

  = New.PK

WHERE New.PK IS NULL

 AND NULLIF(LTRIM(RTRIM(ISNULL(Name,'')+ISNULL(Phone,'')

  +ISNULL(CallResult,'')+ISNULL(CallDate,'')

  +ISNULL(CallTime,''))),'') IS NOT NULL

GROUP...

I just noticed your OS is XP, best to use a Server OS to take advantage of the /3GB switch for BOOT.INI, SQL Server 2000 Developer Edition will only use...

Swap steps 1 & 2, Since you state that you are using a stage tables (emptied by TRANCATE TABLE) for bulk loading, move the BEGIN TRANS after the bulk loading....

If you do choose the Decimal data type, be aware that ADO datatype conversion treates it as a character string as you can define a Decimal with a precision that...

SQL Server is not alone here...

VB VBA & MSBASIC

http://support.microsoft.com/kb/q42980/

Excel

http://support.microsoft.com/default.aspx?scid=kb;en-us;78113

GNU

http://www.gnu.org/software/gsl/manual/gsl-ref_39.html

SUN

http://docs.sun.com/source/806-3568/ncg_goldberg.html

.NET

Many people are finding this out the hard way, Single and Double are IEEE floating point datatypes as...

This is actually due to the dreaded IEEE floating point rounding error.

Use of Money datatype instead of Float datatypes will never have the same problem.

Older versions of SQL Server BOL...