How to count Number of Records

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

HI,

I have table student

st_id , st_name, act_date

1 james 2/2/2012

2 albert 2/4/2012

3 johnson 30/1/2012

4 hitler 2/2/2012

you can see the first record the act_date is 2nd Feb 2012.

Addign one month to Every record.

Ex:

Today date is 23rd Feb 2012, see the first record 2nd Feb 2012.

2nd Feb 2012+adding One Month=> 3rd March 2012.

When i logined into my web site (23rd Feb 2012) , it has to show the count Zero.

When i logined into my web site (3rd March 2012), it has to show the count=2 i.e the 1st record and 4th record.

Same process wlll have to follw to other records.

How to write a Query to count that records based on that condition adding after one month to the record.

Thanks,

Posted 22-Feb-12 14:27pm

Member 4391175

Add a Solution

Comments

Sarvesh Kumar Gupta 22-Feb-12 22:09pm

When you login into web site on 3rd march then you write count 2 but should be 3. Record 1, 3, 4. i m right?

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Bun Leap_kh · Answer 1 · 2012-02-22T14:40:00

Solution 1

SQL

Select RecordCount=count(st_id) 
from student 
where datediff(day,dateadd(Month,1,act_date),getdate())=0

Please let me know if the above query doesn't match what you want.

Posted 22-Feb-12 14:40pm

Bun Leap_kh

Comments

Sarvesh Kumar Gupta 22-Feb-12 22:10pm

not 0, should be less from getdate()

Sarvesh Kumar Gupta · Answer 2 · 2012-02-22T16:13:00

Solution 2

Hi, use below query

SQL

Select RecordCount=count(st_id) 
from student 
where dateadd(Month,1,act_date) <= getdate()

Posted 22-Feb-12 16:13pm

Sarvesh Kumar Gupta