CirquedeSQLeil (2/19/2010)

---

Grant Fritchey (2/19/2010)

---

If you haven't submitted anything to Tony Davis at Simple-Talk, head on over there. His editing process can feel a bit like a prison rape, but you'll...

I love that movie!...

So what you're saying is we should invest in SA telco?

I always thought it was Duct Ape?

jcrawf02 (2/18/2010)

---

Gianluca Sartori (2/18/2010)

---

GilaMonster (2/18/2010)

---

Logical order of the index - yes

Physical order of the...

Andy DBA (2/18/2010)

---

All costs? Sounds like trolling, to me. I know my...

Odd, when I force a negative value, it doesn't change the identity incremental value at all? Try the last code, but set to negative anything, I assumed it would then...

Paul White (2/18/2010)

---

Dan Guzman - Not the MVP (2/18/2010)

---

Also, in this case, using the serial number does not guarantee the order of flower and apple, since the serial is 6...

simplest answer might be to replace the loop with a join to a Tally table, see Jeff Moden's article on the subject: http://www.sqlservercentral.com/articles/T-SQL/62867/

There may be a better way to do...

Grant Fritchey (2/18/2010)

---

Oh jeez, I'm so stupid. I never even thought about that. No wonder everyone gets so many points. Here I am trying to honestly answer the questions... I...

Gianluca Sartori (2/18/2010)

---

GilaMonster (2/18/2010)

---

Logical order of the index - yes

Physical order of the data...

That's not entirely true though, if you SET IDENTITY_INSERT ON, you can force identity values that are out of sequence:

CREATE TABLE #temp (iRow int identity(1,1),something char(1))

INSERT INTO #temp

SELECT 'a' UNION...

Alvin Ramard (2/17/2010)

---

Steve Jones - Editor (2/17/2010)

---

Alvin Ramard (2/17/2010)

---

Well, looks like I'm gonna have fun over the next few days. I've decided to upgrade my laptop to Win7 -...

complain about the lack of process improvement...until the shoe is on the other foot, then CYA

Replacing a cursor with a while loop isn't really an improvement, it's still RBAR.