I can't make heads or tails out of all those unions but, I will offer that, switching to a set based approach will definitely yield performance improvements you're looking for....

Nice, much closer. In that line you changed, I modified it to partition by client code instead of employee code and that got it very, very close:

ROW_NUMBER() OVER (PARTITION...

Hi cm62587, something like the following is what you're looking for...

Assuming the column with the two-character code is in the same table:

UPDATE emailAddresseTable

SET emailColumn = codeColumn + RIGHT(emailColumn,...

Yeah I very much appreciate your time, I took your suggestion with the CTE and I've tried quite a few things with it, none of which were any more successful...

The only way I can get it to work is to use subqueries, but it is one UGLY query:

select *

from (

select top 50

are.client_code,

are.client_name,

eo.country_id,

(

SELECT...

yeah I see what you're trying to do...sort of...

interestingly, for the first three rows, the top manager shows up but in the wrong column. The first row has the top...

Thanks for the response however that results in the exact same error I have now.

It seems you're trying to use CTE's which sounds like a reasonable suggestion. I'll pursue that...

That worked by the way. I put it in simple, then ran shrinkfile, then put it back to full. It's 24 MB now.

I'd like to make sure I understand what I am supposed to be shooting for here. My understanding is that you take backups every so often, and then you run...

The data from the failed application came from a PostgreSQL database. The app is a website and it lets you export to a spreadsheet but it came from that open...

Line feed character...I have no clue why that was put in there. Interestingly it was not put on the first column in the spreadsheet, but it was put on every...

I did try Gail's suggestion and it returned what we all would expect: the value with no trailing spaces.

I also ran:

select CONVERT(VARBINARY, 'abc'), CONVERT(VARBINARY, 'abc ')

and the second...

mister.magoo, I think you're on to something here.

I ran:

SELECT CONVERT(VARBINARY, ClientRelationship), CONVERT(VARBINARY, 'Client')

FROM InitialImport ii

WHERE [Name] = 'Some Guy'

There seems to be a trailing A0 on the...

Yeah, thanks for the response Jesse but I'm not sure you understood what I was asking. It definitely doesn't have anything to do with trimming spaces.

mister.magoo, I attempted both...

I already ran:

UPDATE MyTable

SET myColumn = RTRIM(LTRIM(myColumn))

to make sure there were no spaces interfering, so that's not the problem. I already checked it with both trim functions anyway and...