You can use a CTE to create a partitioned row number and update this CTE.

DECLARE @T TABLE (Bldg INT, Job VARCHAR(20));

INSERT INTO @T

...

Glad we could help

Using a a Tally table to create this range of items is just simple. If you don't know what a Tally table is, please search this site. You will find...

I think ROW_NUMBER is the wrong function in this case. Try RANK or DENSE_RANK:

SELECT DISTINCT

DENSE_RANK() OVER (ORDER BY fldCID),

fldCID

FROM @Test

Oups... didn't read your statement correct. This should work:

UPDATE a

SET a.BatchID = b.Id

FROM Audit as a...

Hi

I don't understand the relation between this sentence...

Hi

Thanks for the sample data. 🙂

Try this:

UPDATE st SET

st.Code = ISNULL(r1.Code, r2.Code)

FROM #SpecailtyTeam st

JOIN #REF...

A hint for future projects and implementations...

Don't create dynamic SQL statements containing values in your font end. This enables SQL injection and causes problems as your current. Use parameterized statements...

Paul White (6/23/2009)

---

Florian Reischl (6/23/2009)

---

Just remembered a thread about two month ago, you posted some code with font size 5 (I think). It looked fine in Chrome as you wrote...

GilaMonster (6/23/2009)

---

How far are you from Berlin? There's a very, very, very, very small chance that I may be in that...

Paul White (6/23/2009)

---

Oh - ha ha ha 😉

Actually it renders just fine in Chrome 2 - albeit somewhat faster than...

lmu92 (6/23/2009)

---

Accommodation for Oktoberfest should be okay. I cannot guarantee...

@WayneS

These OLE thinks are the reason why I'm really glad about the CLR integration in SQL Server 2005 and above.

@roy: You just have to come to Germany.

@Gail: (S)He will answer when (s)he really gets performance problems. 😉

:-):hehe::-D:-):hehe::-D

6000

:-):hehe::-D:-):hehe::-D

@paul-2: Probably looks better in IE or Firefox 😉