I do not have any excel files open. Where do I look to show what is wrong? I am logged in using the admin account and the letter is...

It wouldn't.

No one suggested removing the double quotes from the file.

If double quotes are field delimiters (which is a bit weird), why are you worried about commas?

I think maybe that you explained it slightly incorrectly and should set the text...

So you want to be able to capture the text of the actual T-SQL query which was executed so that you can paste into a query window in SSMS and...

Your post is difficult to understand, can you explain in more detail?

You expect us to diagnose a job...

I call this an error message.

What do you call it?

No. I'm a SQL Server guy....

Presumably you understand the error message? SQL Server thinks that you're scheduling the job in the past. What timezone is the server in? Is the server date/time correct?

Thank you Jeff. Yes I am painfully aware that the code is different. It took me a very long time to figure out the SQL query and am really...

Unless you are required to do this for legal purposes, it's more trouble than it's worth.  Just assign identity or a date/time field when you create the record and...

I thought that...

Do you want a stored proc to do this?

Are all of the detail rows created at the same time as the parent?

What is the PK of the detail table?

What is your objective? What extra benefits do you think a cursor will give you?

>> Also, considering that VALUES didn't actually come out until 2008, your lecture about getting rid of the old syntax "decades" ago is full of hooie.<<

If my arithmetic is...