hi how to create sp to get total no of request within dates?

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

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 1:40am

ythisbug

Add a Solution

1 solution

Add a Solution

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

OriginalGriff · Answer 1 · 2013-02-24T01:55:00

Solution 1

Easy:

SQL

SELECT COUNT(*) FROM MyTable WHERE MyDate BETWEEN DATEADD(DAY, -30, GETDATE()) AND GETDATE()

and so forth

Posted 24-Feb-13 1:55am

OriginalGriff

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

hi how to create sp to get total no of request within dates?

1 solution

Solution 1

Add your solution here

Preview 0

hi how to create sp to get total no of request within dates?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us