[thelist] SQL query to create aging buckets

Jay Blanchard jay.blanchard at niicommunications.com
Wed Dec 17 15:30:28 CST 2003


[snip]
I'm trying to figure out the SQL (on MSSQL) to group results after
rounding. Here's the query I'm running:
 
  select datediff(d,duedate,getdate()) from tasks 
 
against data which looks approximately like this (not necessarily the
real data):
 
  2003-12-05 14:57:19.000
  2003-12-05 17:00:09.000
  2003-12-05 17:04:24.000
  2003-12-06 09:52:28.000
  2003-12-06 16:01:30.000
  2003-12-08 09:16:16.000
  2003-12-08 11:28:43.000
  2003-12-08 12:39:00.000
  2003-12-08 12:47:11.000

which returns a list like this:
 
  12
  12
  12
  11
  11
  9
  9
  9
  9

I want to see a count of each number, thus:
 
  3  12
  2  11
  4   9
 
Seems like it should be possible, but it's not coming to me in a vision
or anything
[/snip]

*shimmering* A cross-tab query perhaps? 


More information about the thelist mailing list