Jeff Moden (3/21/2009)

---

Lynn Pettis (3/20/2009)

---

You know, I was looking at...

Jeff Moden (3/20/2009)

---

Lynn Pettis (3/20/2009)

---

Jeff Moden (3/20/2009)

---

Lynn Pettis (3/20/2009)

---

Jeff Moden (3/20/2009)

---

Heh... nope... I don't believe I ever wrote that... If it were for a sequence table, I'd have written something...

Jeff Moden (3/20/2009)

---

Lynn Pettis (3/20/2009)

---

Jeff Moden (3/20/2009)

---

Heh... nope... I don't believe I ever wrote that... If it were for a sequence table, I'd have written something like the following (partial...

Jeff Moden (3/20/2009)

---

Heh... nope... I don't believe I ever wrote that... If it were for a sequence table, I'd have written something like the following (partial code)....

UPDATE NextID

...

Richard Fryar (3/20/2009)

---

Lynn,

Beware the typo. You put 365 instead of -365.

snehal.gamaji.career,

Create a clustered index and go with Lynn's suggestion. Your WHERE clause is not SARGable, and will perform...

foxjazz, I hope you leave this thread with more than just the knowledge we tried to impart. I hope you have also learned that there are quite a few...

Jeff Moden (3/20/2009)

---

Derek Dongray (3/20/2009)

---

It looks like The Rant has run its course.

And from his description of his setup (sync software + 3 application tools + 5 databases), I don't...

From what I can tell the mistake is already made. The question is CAN they fix it up or would it require a rewrite of their software system. ...

Jeff Moden (3/19/2009)

---

foxjazz (3/19/2009)

---

I think this is the query I arrived at for getting the next PK value.

select @currentval = max(Convert(int,substring(GenLevelAddFieldID,len(@@servername) + 1,10))) from tblLevelAddFieldRel where GenLevelAddFieldID like @@servername...

Derek Dongray (3/19/2009)

---

Lynn Pettis (3/19/2009)

---

Whoa! I think we had an epiphany!!! From The Rant:

foxjazz (3/19/2009)

---

Lynn, you have completely and utterly convinced me to look for a set based...

Luke L (3/19/2009)

---

GSquared (3/19/2009)

---

It only took six to turn him from a semi-spoiled, annoying brat into a dead good-guy, with much of the transformation being spent in the "teen angst...

Thank you for...

Whoa! I think we had an epiphany!!! From The Rant:

foxjazz (3/19/2009)

---

Lynn, you have completely and utterly convinced me to look for a set based solution to the problems...

Tell me, please, did it hurt? 😉

Suprise...