I'm afraid more information is required.

I am not seeing the pattern between the desired output and your input.

Is there a sequence?

Are...

See if these are quick enough for you. The use of FOR XML is the fastest concatenation technique I've come across, but this sort of string manipulation is...

For what it's worth, JOIN is the standard we use too, for both readability and reliability.

Hopefully some of the rest of us will be on hand to listen.

What a maroon... what a gulli-bull...

I would follow Magoo's approach of making this table-driven for the sake of flexibility.

Might be a good idea to add an index to his ReportKeys table.

Hey... who are you callin' an oxymoron!? :unsure:

Hi Flo:

No I don't create them, I use Google Image Search, and there are also websites that post collections of images. "Biohazard" seems to inspire a...

I must confess, I don't approve of your schema either.

However, this will give you the result you're looking for.

declare @test-2 table (PK1 int, pk2 int, TitleOrder int, Title varchar(20),...

By the way, Gail. I asked for authority instead of experience because you can usually quote chapter and verse from BOL. 😉

I just tested it and answered my own question. The Join on ShortCode+'%' did NOT interfere with the proper use of the index. It produced...

I was thinking about the LIKE solution earlier, but that would make the join be

INNER JOIN T2 ON LongCode like ShortCode+'%'

Doesn't the ShortCode+'%' expression create the same problem as the...

Gail, do you have some authority for us on the joins using the LEFT function?

You should feel safer now, too. 😉

:w00t: