Using my last post as my working theory, here is some code to work with:

create table #MyTest (

CompanyName varchar(50),

CompanyID varchar(10),

...

Here is the snippets of data from your post:

A & H RESTAURANT & BAR SUPPLY PA ...

I've been working on this for 4 hours last night (8:00 Pm to...

And which log you saw it in.

I'm guessing I'm too close to the trees to see the forest.

My eyes are going buggy still, Jack. Any way you can "point out" where you saw that in the logs for me?

I think it also depends on what version of SQL Server 2005 you are applying SP3 to as well. So far I have had no problems with SP3 installs...

Here are the logs from both servers.

For those of you following this thread, I am at work and I am getting the logs ready now. I will have them posted in the next 15 minutes...

We keep learning. I don't want any young'ns showing me up if i can help it.

Only reason I jumped up front was because of Christmas break. Of course I'm off over Christmas as well, but not much else is going on as we are...

Why aren't you just using an OS Command line step in your job to run the executable? There really is no need to use T-SQL and xp_cmdshell to do...

Well, if we ever had IT, I think we lost IT. If anyone has found IT, please return IT.

Thanks! :w00t::P:w00t:

No, no, no. It's "Thank you, now let's go out for a drink or two or ..."

Then you did something wrong, because I just cut and paste the code from my post here at home and ran it. ...

Why did you have to use a DISTINCT? My code returned exactly what you requested, based on your sample data 62 rows.