That's what I get for answering email before the necessary amount of coffee...

Heh... I don't think performance is the "black art" that so many think and, I agree... sometimes new hardware and SQL Server upgrades just don't do a thing...  

3 years ago,...

Dang... I gotta get 2k5...

Heh, I noticed the Peter converted the code to the good'n'proper ANSI style joins so that it's apparent that...

It was a funny comment, indeed.

No, we're not make fun of anyone except for each other  

But, I was serious about needing to...

Now, THAT's funny!

Perfect...

Obviously, you need to test this on a copy of the table before you try it on the real table...

 DELETE ad1

   FROM dbo.AilmentDetail_Test ad1,

        dbo.AilmentDetail_Test ad2

  WHERE ad1.AilmentID      ...

Heh... if you find the "other guy", give him a punch in the nose for me, huh

I agree with Michael... step 1 should...

I'm thinking there better be a reference in the two tables that directly relates the rows, as well...

smknox

The reason we need to see the rest of the table's definition is because we need to identify a column with some...

Those are all good suggestions and I'll suggest a bit more to go with those... put the Archived years in their own "read only" database, back it up once, and...

Susan,

Please post what you figured out... thanks.

Y-e-e-e-o-o-ow!  Cursors, Ali?  You don't need cursors for this... James and Tomm are correct... import the whole file into a very wide staging table and then have a process for...

Guess I don't understand... Oleg's code seemed to work fine for all conditions according to what the OP wanted... here's the code again...

select

 replace(ltrim(replace(data,'0',' ')),' ','0')

from @Temp

That's cool... you should post the site in the Jobs forum with that info... you'd be surprised at how many bites you get.  You can even do it a couple...

Heh... I guess I'll never understand that...

Rainer, what say thee?  It's always an interesting topic... why is it that your users are allowed to create views without going through...