Wow, it works! Thanks so much Lynn. I replaced the line you partially commented out and added the two lines up near the top and it worked perfectly....

Here it is:

use msdb

go

begin transaction

declare @ReturnCode int

select @ReturnCode = 0

if not exists (select name from msdb.dbo.syscategories where name=N'[Uncategorized (Local)]'

and category_class = 1)

begin

exec @ReturnCode = msdb.dbo.sp_add_category @class = N'JOB', @type =N'LOCAL',...

Yes I did make the original change that Robin suggested. My reply is right after that (The third down if you count my original question as 1). I...

Thanks Lynn. I tried that and I still got the same error about the '+' character/operator. If it had been the problem I would have been in for a...

Thanks Robin for the super fast reply. I'm afraid that I cannot get it work within the context I'm using it though. Please let me know what I'm...

Great improvement. Plus it's just way more elegant and isn't a stray exe sitting out on an app server somewhere. Thanks!! My boss couldn't believe how nice you...

Sorry for the late reply Elliot. I found out that it takes about 3 minutes to run. It doesn't have too many records to process each day though.

I'm sorry but I don't know because it is currently in production running on a job server via Windows Scheduler. I don't have security access to any of it....

Elliot, I don't know what to say. You are the best!! I have been working on something else for the last couple of days so that's why I didn't...

Cool. Thanks! I'll be very interested to see.

Sorry to hear you were sick. I hope you are feeling back to normal now. Please don't worry about my problem if you're feeling peaked. Thanks for all...

Also found out that I can go to "project" in the main menu of my visual studio project and select "show all files" to see the Form1.resx file in the...

In case anyone is interested, I found the "missing" SQL command in the resx file in XML:

<data name="SqlSelectCommand1.CommandText" xml:space="preserve">

<value>SELECT csh.*

FROM ...

Thanks Jeff!

I found this one that queries the ClkCaseHdr table joined to the CaseStatusHist table :

exec sp_executesql N'SELECT csh.*

FROM ...

Thanks Matt. I can definitely do that. I'll post again when I see what is happening.