Correction - I meant to say that "When I logged onto the server as the job starts."

Ok. Here's the complete error message. Remember, if I am logged onto the job as the jobs starts, the job would finish fine, without any error at all.

Date4/1/2010 4:00:00 AM

LogJob...

Got it. Thank you!

First of all, let's assume that your first column has unique value.

Second, let's name the columns as Col1 through Col5.

DELETE FROM YourTable

FROM YourTable LEFT OUTER JOIN

(SELECT Col3, MAX(Col1) AS...

Thank you.

Here's another option, I think...

SELECT part,

SUM(qty)

FROM parts

WHERE (part = 'A' AND locationTo =1) OR

(part='A' AND locationFROM = 1)

GROUP BY part

Cheers

I used to have codes to do exactly the same thing. I think the key is to use the following syntax:

EXEC @ProcName @Parameter1, @Parameter2

Good luck!

YCH

THANK YOU!

THANK YOU!

Thanks for prompt responding.

I should have been more specific on this. What I wanted to do is to find out the SPID from the Client side which is written...

Thanks for your help.

I used David's solution to Open the file in Binary mode.

Thanks for your replies.

The file size is small for our discussions. I have also tried to do things in VB to clean up the records. For example, I open the...

Wel, I think I solved this one myself.

Make sure to click on "Transform" button and have the "Enable Identity Insert" check box unchecked.

quote:

---

You can do it this way....

create proc abc123 as

exec('CREATE DEFAULT dftMyDefault AS ''0''')

Cheers,

Prakash

---