You want to affix an "A" to the end of a duplicate, right? That's easy enough.

What do you want to do if there's more than 2 of a single...

I put in the non-repeat bit because of the way Steve wrote his original Where clause. I just moved it into the Joins.

It depends on what you're trying to get as an end result.

Are you trying to get a grid with:

a,b,c

b,c,a

c,b,a

b,a,c

a,c,b

c,a,b

c,b,a

And variations with more columns, with no repeating values in a single...

Is there anything in there that says which row's ID goes into which row's Value?

It looks like what you're trying to do is take the next row, and put it's...

roger.plowman (5/17/2011)

---

I think the point about being risk-averse is absolutely true--and gets the cart before the horse.

Think about it. Would *you* want somebody who enjoyed high-stakes risk taking being a...

Ninja's_RGR'us (5/17/2011)

---

Why are those the only 2 options?

Why can't we have fun getting done what needs to be done and go home after that? No need for long NOR...

"Best" will depend on your database and what else is going on in it.

You could use sys.columns to identify all table columns that can contain textual data (varchar, char, nvarchar,...

Makes sense. Glad we could help.

Nah. My brain knows...

Ninja's_RGR'us (5/18/2011)

---

I'd have used sp_WhoisActive (parameter for system transactions = 1). Maybe that can give you another hint.

I never faced that issue so this is more of a shotgun...

Stefan Krzywicki (5/18/2011)

---

GSquared (5/18/2011)

---

Lynn Pettis (5/18/2011)

---

I know I'm late to the party, but I was reading the question and I'm partially lost, in that I'm not sure what your expected...

SELECT *

FROM sys.dm_tran_locks

WHERE request_session_id < 0;

Returns zero rows.

Does that look like the right query for that?

It's sometimes surprising what blindspots we don't realize we have.

I ran into a minor one at the SQL Rally last week.

I thought this would be non-SARGable and would result in...

The way to move your thinking from rows to sets is "stop thinking about what you want to do to a row, start thinking about what you want to do...

Lynn Pettis (5/18/2011)

---

I know I'm late to the party, but I was reading the question and I'm partially lost, in that I'm not sure what your expected results are based...