Evil Kraig F (8/25/2011)

---

Wayne,

Excellent examples and a solid walkthrough, thank you.

Btw, for your question about real-use of range, you'd have to wrap the results in a distinct.

I'm thinking of log-entries. If you want by day-running totals, you'd do a by range and then distinct the results on the summed columns and the leading identifiers. This way if 2 ppl worked on a project 1 day and 10 people the next you could still have 2 rows, one identifying each day after the distinct with the correct totals.

mishaluba (8/27/2011)

---

I had no idea you could use PARTITION BY with things like MIN, MAX, COUNT, etc.

Thank you for the article!