Heh... it'll be interesting to see what sort of panic they go into if they ever go over 17576 customers. Thanks for the great explanation.

No, I sure don't, Barry. I looked but I've got so many posts and there's so many wierd post names, I've not been successful at all. Thought I'd...

If that's true, I'm very happy for me but I'm really sad about the folks they let go. Most of them were really good people that I'd go back-to-back...

Understood and much appreciated, Micheal. Thanks. But, look at the data in the example... it's not ranking anything. It's simply building a seqence of how many times...

Thanks Jack... appreciate your time.

Rayven (1/16/2009)

---

Jeff: Any jobs going at your place? Initiative here tends to be welcomes with a ".. and why were you wasting company time?" before they have even evaluated the...

smunson (1/16/2009)

---

Jeff,

I hope you're not lumping me in with the "some answers that aren't quite right" group... at least I was the post with the REPLACE idea for...

Piotr Rodak (1/16/2009)

---

I came across the 'top 5' requirement. I needed to identify rows that have some values not smaller than 5 biggest values in the table. I guess it's...

TheSQLGuru (1/16/2009)

---

Tempdb constraints come to mind here. 🙂

I sure do wish someone with CLR knowhow (and some free time) would take the opportunity to do some CLR code you...

Does the target table exist to begin with?

There is no need for a cross-join on the date table to get all of the dates... it should be an outer join, instead. That is likely your performance...

TheSQLGuru (1/16/2009)

---

Jeff, it strikes me that pretty much all of your examples here and in other threads have a clustered index on the key of concern. What happens when...

I must have something whacky going on with my machine... it gives me an XML error when I try to open the excecution plan.

I have no doubt that the IO...

LOL! Oh Lordy, that's what I'm starting to think about the reasons behind this problem. 😛

Jeff Moden (1/13/2009)

---

I am certainly looking forward...