Tom.Thomson (8/30/2011)

---

Nice and straightforward.

I have a strange feeling that I've seen exactly those two queries before somewhere.

But maybe I won't cry "plagiarism" .

Or maybe I should?

stewartc-708166 (8/30/2011)

---

Nice simple question.
Having recently embarked on a project which requires the use of grouping sets really helped

Daniel Bowlin (8/30/2011)

---

I did a little reading, got the question right, but the reading I did makes me want to read a lot more about commands I have not used in the past that I think I will find quite useful. Thanks

Revenant (8/30/2011)

---

Thank you, Dee! It compelled me to re-read GROUPING SETS.

tim.kay (8/30/2011)

---

Thanks for this question. As a relative newbie I think I will find this useful in future.

SanDroid (8/30/2011)

---

Thank you Tom.
It was your reply to my comments that inspired me to write this question.
So I would call it inspiration before plagerism.

This question is based on one posted before.
http://www.sqlservercentral.com/questions/T-SQL/64301/
The example scripts, and the answer, are not the same.