Taking a guess that is the first version you are looking for.

Something like should get you started.

;with CityData(City, Country) as

(

select 'Madrid', 'USA' union all

select 'Madrid', 'Spain' union all

select 'Madrid', 'Brazil'...

Which version of Kraig's is...

Yes but a slightly different approach to cracking the same nut. Same result, different execution plan. Hard to...

In your description you said you wanted Country but in your code you used ContactName. Could it be as simple as using the correct column?

This should work for you. Thanks for the clear explanation and ddl and sample data. That makes this kind of stuff a zillion times easier.

select * from

(

select ROW_NUMBER() over (PARTITION...

sheesh in looking at my post I could have been a...

This looks an EAV type of system with the addition of datatype?

Jaat (5/2/2012)

---

I´m sorry i did not know the rules to answer something, but based on best practices we should avoid making string operations on the database side for performance that´s...

DBA_SQL (5/2/2012)

---

I Tried the following update statement, but it didn't worked.

update scramble

SET FNAME = T1.Fname,

LNAME =T2.Lname

FROM(

SELECTFNAME,

ROW_NUMBER() OVER (ORDER BY NEWID()) AS recID

FROMSCRAMBLE

) AS t1

INNER JOIN(

SELECTLName,

ROW_NUMBER() OVER (ORDER...

OK let's use this one then.

Duplicate post...ignore this thread and instead view the one with an answer.

http://www.sqlservercentral.com/Forums/Topic1294098-1550-1.aspx

LOL. did that get it for you then?

Lynn Pettis (5/2/2012)

---

patrickmcginnis59 (5/2/2012)

---

Sean Lange (5/2/2012)

---

patrickmcginnis59 (5/2/2012)

---

Sean Lange (5/2/2012)

---

Well unless you are doing on the most god awful things I have seen some sql people do...which is to create a...

It can get really difficult to test this fairly easily. It is difficult to test the second proc. You have to go back and figure out how to create the...

So get the right 2.