Thanks to both of you!

'7/1/' + CONVERT(varchar, @NEXT_YEAR) works!

Jonathan

Works like a charm!  Thanks for the help.

Jonathan

Thanks David,

I suspected as much about the sa account.

When I configure the task in Task Scheduler I am given the opportunity to enter the account to run the batch file...

Worked perfectly!  I have control over job names so not concerned about length.

Thanks a million!

Jonathan

Thanks everyone for your help!

Jonathan

Thanks Gary,

Can you give me an idea of how to have the job insert a row in the logging table only if the job fails? 

Thansks again.

Jonathan

Thanks for your suggestions!

Steve, would it be possible to share the script with me as it is now?   If not no problem.

Jonathan

Thanks!

I am rather new at dynamic sql and had it in my head that a parameter cannot be used as an object name (requireing a cmd string to be built...

Thanks all for your suggestions!

I did use dynamic sql to get this done. This sp will be used infrequently by only a small inhouse group of techies so I...

Thank you all,

Just had time to get back to this. I also found the following:

http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm

JM

Lee is correct. I am looking for Procedure_ID's that do not have a profile of 13.

Thanks anyway for your suggestion Venkata.

THANKS! Worked perfectly.

Such a simple task ... not so simple to code.

JM

Thanks for your checking!

It appears my problem was with empty strings. Converting them to NULL allowed the CONVERT function to deal with them.

You are correct, varchar can be converted...

As I loop through the recordset, I am checking for empty strings and replacing with NULL. This is then put into the CONVERT(decimal) function. This solved the problem.

Thanks

JM

...

There are no numbers that large.

I just noticed that some records have no value for the field in question. They seem to be coming from Progress as an empty...