Excellent. Sometimes you have to break the rules.

But if...

Gianluca Sartori (3/27/2012)

---

GSquared (3/27/2012)

---

L' Eomot Inversé (3/27/2012)

---

Stefan Krzywicki (3/27/2012)

---

GSquared (3/27/2012)

---

[It's a lot of posts, but I've never understood any fascination with "milestone" posts. Number in Hex, Oct, or Bin,...

Did your professor say you had to do it in one step? If not, declare a variable, calculate the average and assign that to the variable, then query the...

L' Eomot Inversé (3/27/2012)

---

Stefan Krzywicki (3/27/2012)

---

GSquared (3/27/2012)

---

[It's a lot of posts, but I've never understood any fascination with "milestone" posts. Number in Hex, Oct, or Bin, and you get...

By the way, the reason I call it Numbers instead of Tally is the definitions of the words:

Tally:

NOUN

tal·lies plural

1. record of items: a record or account of...

Yep.

I usually start mine at 0 though, because there are uses for that. Easy enough to subtract 1...

A table of Numbers. Like...

You're welcome.

It's one of those seriously non-intuitive things that can bite anyone, rookie or no.

Here's what I was able to come up with as a sample solution. I imported your CSV file into a table called SampleData, and queried it this way:

;

WITH ...

GilaMonster (3/27/2012)

---

Jeff Moden (3/27/2012)

---

GilaMonster (3/27/2012)

---

Is it just me, or does a term like 'That can be done, but people usually learn better' rankle when applied to something you've said?

Feels...

Ah, just assign everyone a GUID and make them memorize it. Nobody could possibly be masochistic enough to try to memorize someone else's GUID.

More seriously, GUIDs would be a...

Stefan Krzywicki (3/27/2012)

---

GSquared (3/27/2012)

---

WayneS (3/27/2012)

---

Is anyone else noticing that The Thread is almost at 35,000 posts? Looks like today could very well be the day. (Expecting Alvin to jump in...

Stefan Krzywicki (3/27/2012)

---

It is amazing how, no matter how often I state "I am not interested in travel or relocation", when I mention that on my resume and list it...

WayneS (3/27/2012)

---

Is anyone else noticing that The Thread is almost at 35,000 posts? Looks like today could very well be the day. (Expecting Alvin to jump in and get that...

Can't give you a BOL reference on it, because Microsoft doesn't actually define the sort orders for the Unicode character set. That's done by a standards body. So,...