Chris Morris (12/19/2008)

---

dejanette.gordon (12/19/2008)

---

All of the values are numberic and 85 rows of data have the leading R. The sorting I am looking for is all the numbers in numberic...

Dejanette,

I am sure you would help if you could. My problem is with applying SP 3 to a multi-instance x64 server running SQL Server 2005 Developer Edition.

If you can't...

And if that works, I could use some more thoughts on a problem I am having...

Okay, hows this??

create table #MyTest (

CompanyName varchar(50),

CompanyID varchar(10),

RegionID char(2)

);

insert into #MyTest

select 'ANDERSON DAIRY PRODUCTS ...

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...