Monthly statistics

Scott's Blog

Thursday, February 4. 2010

Monthly statistics

If you have a table with a datetime column and you want to group the rows by month, then this can help:

select count(*), datediff(m, datetime_col, getutcdate())
from table
group by datediff(m, datetime_col, getutcdate())
order by 2
Posted by
Scott Waye
in SQL Server at 10:18 | Comments (0) | Trackbacks (0)
Trackbacks
Trackback specific URI for this entry
No Trackbacks
Comments
Display comments as (Linear | Threaded)
No comments
Add Comment
Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA

 
   
 

Calendar

Back September '10
Mo Tu We Th Fr Sa Su
Thu September 9 2010
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30      

Quicksearch

Archives

Categories



All categories

Syndicate This Blog

Blog Administration

Open login screen

Powered by

Serendipity PHP Weblog