August 22, 2008 at 10:09 pm
How would you setup the sql to display data that looks like the following:
typePrevious MonthCurrent Month Differencecount (%)count (%)ChangePercent (%)
type114 1.72%9 24%-5-35.71%
typew0 0.00%0 0%00.00%
type30 0.00%0 0%00.00%
type40 0.00%1 4%10.00%
type5800 98.28%27 73%-773-96.63%
Total814 37 -777-95.45%
August 22, 2008 at 10:42 pm
Please review this article: Best Practices: http://www.sqlservercentral.com/articles/Best+Practices/61537/
For your question, lookup the GROUP BY operator in Books Online. Based upon what you have posted, that is the best guess I have about what you want to do.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply