I apologize if my response sounded a bit snarky. I totally get what you mean that you had to simplify it. And of course once you group by a zillion columns it may no longer return 1 row.

By all means don't write this place off as a solid resource. Those of us that post sometimes get bogged down by the lazy people who just want their answer right now because they are under a time crunch and as a result we can sometimes sound a bit snarkish. Sadly the quality of the help is direct result of the quality of the post. Given that you basically said to ignore it I probably should have. Instead I chose to give you an answer to your simple question and berated you at the same time. My apologies.