tt-615680 (5/3/2012)

---

Dear All,

I would like to find more about the Disadvantages of Transactional Replication as it is the best process of Replication for my Business needs; I would like to...

You have a couple things going on here. First your query is using the old style join. While syntactically correct it is very hard to read these types of joins....

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...