Click here to Skip to main content
12,067,652 members (50,558 online)
Rate this:
 
Please Sign up or sign in to vote.
hi
how to create query to get details of how many request i got within 30 days and 30-60 days
and 60-90 days and >90days
can any one suggest me?

thank you
Posted 24-Feb-13 2:40am
ythisbug2.1K

1 solution

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Easy:
SELECT COUNT(*) FROM MyTable WHERE MyDate BETWEEN DATEADD(DAY, -30, GETDATE()) AND GETDATE()
and so forth
  Permalink  
Comments
ythisbug 24-Feb-13 23:55pm
   
thank you.but this query counting all.nt like within one month i mean in 30 days hw many request i gt
OriginalGriff 25-Feb-13 3:13am
   
And how do you determine if something is a "request"?
ythisbug 27-Feb-13 4:45am
   
for example i told request..
actually am selecting itemid and two dates to get total count withing 30 days
OriginalGriff 27-Feb-13 5:00am
   
So just modify the WHERE clause...
ythisbug 27-Feb-13 5:18am
   
ok thank you

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web02 | 2.8.160208.1 | Last Updated 24 Feb 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100