That sounds like it might work.  Let me go try it out and see what happens.  Thanks!

I forgot to mention that I really can not use a temp table to store a second copy of TABLE1.  There are several DTS jobs that are doing something similar.  Each...

Where can I get xp_md5?  We're storing the password using MD5 encryption on the front-end using Cold Fusion's "hash" function.  I also need to have this same function at the...

Correct.  I can hardcode the columns and it works just fine.  I just need it to be more dynamic so that it'll also work when a City is added/deleted.

fhanlon's link...

That query returns the same thing as:

SELECT * FROM Rate

I've gotten it to resemble the Excel file using:

SELECT From_City,

    SUM(CASE To_City WHEN 'Los Angeles' THEN Cost ELSE 0...

The table is named "Rate" with 3 fields:

1)  From_City  varchar(50)

2)  To_City    varchar(50)

3)  Cost       int

It's a simple table, but is giving me a very big headache...

If you need more info,...

If you really wanted to you can.  Just create a table like "sp_Status".  In your sp, just insert a record into sp_Status with some description at whatever steps/points you want. ...

CREATE PROCEDURE sp_IsJobRunning

   @JobName as varchar(100) = Null

AS

-- Create a temporary table to hold job info

CREATE TABLE #Job (job_id                UNIQUEIDENTIFIER NOT NULL, 

                   last_run_date         INT              NOT NULL, 

                  ...

Value     Description

0   Returns only those jobs that are not idle or suspended. 

1   Executing.

2   Waiting for thread.

3   Between retries.

4   Idle.

5   Suspended.

7   Performing completion actions....

Ignore the above.

I've used TSQL to delete this invisible backup device:

sp_dropdevice 'master'

It's odd that it's not showing though...

1. Error Message is "Failed (7/17/2003) 4:35:58 AM)". In View History:

The job failed. The Job was invoked by User 323S\SQLADM. The last step to run was...

That is what I thought too. However, subsequent execution (using real production data with blanks spaces in 431-447) only imports every other record. I've verified that it only...