Atif Sheikh (8/5/2008)

---

Hi Jeff..

I executed your script and, surprisingly, got an error. One of my databases was in the recovering status and raised error on that database.

So I altered your...

Heh... couldn't resist, Barry.

Hey! Are you going to PASS this year? Sure would like to do some 12 oz. curls with ya someday. Bring your helmet so...

Very cool, Jacob! Thanks for taking the time to test it and other methods, as well! 🙂

I wish I could take the credit for the code,...

meichner (8/5/2008)

---

Thanks to both Jeff and Jacob for the help. Based on your posts I will use decimal instead of money. I was wondering, since I am only working...

Jacob Luebbers (8/5/2008)

---

Jeff Moden (8/5/2008)

---

...For example, the fastest "missing sequence" code I've ever seen uses a couple of correlated sub-queries which is a form of RBAR... but the constraints it...

The clustered one is the easy one for deletes... the other 9 are add...

rbarryyoung (8/5/2008)

---

Jack Corbett (8/5/2008)

---

I don't know, based on your time in the field from your recently posted article, I feel like I need to show you proper respect and call...

Heck... I wouldn't...

You bet. Welcome aboard and thank you for the feedback. 🙂

Michael Valentine Jones (8/5/2008)

---

I believe there is still a limit of 256 tables in a query (haven't verified that, so I could be wrong), so if you have a lot...

Heh... OUTSTANDING CHRIS! I've been looking for that exact cartoon for a while now! Thanks. And, yeah... it does remind me a lot about the Shenanigans that...

Andy DBA (8/5/2008)

---

Also, the concept of storing a tally table would be a pretty hard sell. "So you're suggesting we have a permanent table of nothing but consectutive numbers?...

Tao Klerks (8/5/2008)

---

Hmm, my curiousity is piqued... The solution presented is quite interesting, but I believe the purported interest in bits and bytes is a little exaggerated, as the solution...

maruf24 (8/4/2008)

---

i hav used exists but there is no use same result...

...... shud i do 1 thing to check the appication.... some one might changed the coding as it run...

Heh... isn't that the way religious wars get started. 😛