select distinct

a1.UF, a1.Code OldCode, a1.Sym,

a2.UF NewUF, a2.Code NewCode, a2.Sym NewSym

from tblA a1

join tblB on tblB.UF = a1.UF

join tblA a2 on a2.UF = tblB.NewUF

Might work?

/T

Amit Pandey DeBugSQL (10/8/2010)

---

Okay, so recreating the table is the only way to claim space.

Sounds like a bug in the product to me.

I think this should have been...

Maybe this could work (with the right index)... though i doubt it. Should probably be worse then the count version. But your the one with the data to test 🙂

;WITH...

mail4sha (10/8/2010)

---

somethg goes wrong on following code where i m trying to get identity value from sequence_emp table... as output of this procedure i m getting null only... insert cmd...

Have to agree with that. Design is horrible. However if thats not possible

--Some tables and data to test against.. since i dont have this

create table dispLookup (Code int, Disp varchar(256)...

Holy One (10/6/2010)

---

There's a lot of beefing and complaining going on here, hearkening back to the early 20th century when doubtless the same complaints were heard about the Ford assembly...

Pretty much yeah. Its "Hay look we think you should develop stuff this way instead... oh and btw we have a product to help you"

/T

Or without a recursive query

select t1.EmployeeID, t1.DataYear, t1.YearlyWage, Sum(t2.YearlyWage)

from @MyTable t1

join @MyTable t2 on t2.EmployeeID = t1.EmployeeID

...

Lynn Pettis (10/4/2010)

---

Craig Farrell (10/4/2010)

---

... Are you simply learning the new technologies to support the existing staff at your current level? Then yes, that's work to me. ...

josh_thoma (10/4/2010)

---

Basically I have a table that stores the definition of a fixed-length record. I want to be able to parse out those records in a .Net app using...

Hugo Kornelis (10/4/2010)

---

tommyh (10/4/2010)

---

Well if one wants to be picky it does return the nr of bytes needed to represent the data. Hence why

select datalength(N'hi'), datalength('hi')

gives 2 different results....

Hugo Kornelis (10/4/2010)

---

da-zero (10/4/2010)

---

Good question and thanks to Oleg for the more detailed explanation.

@nakul: no excuses about having no time to do the detailed reasoning 🙂 Post your...

Carlo Romagnano (10/1/2010)

---

tommyh.

Running the code under 2000 all i get is

(1 row(s) affected)

under 2005 and 2008 i get

Server: Msg 3609, Level 16, State 1, Line 1

The transaction ended in...

Hugo Kornelis (10/1/2010)

---

tommyh (10/1/2010)

---

Also good that Microsoft change the way that SQL handles this. In 2000 you wouldnt have a clue that your insert just got shafted. Atleast in 2005...

Good question, didnt know it behaved that way.

Also good that Microsoft change the way that SQL handles this. In 2000 you wouldnt have a clue that your insert just...