I've never used them, but could GROUP BY CUBE or GROUP BY ROLLUP not be used?
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2007 Indexes