Your selected language is US English
 Is your code a resource pig?
 
 
Team Foundation Server Hosting
Skip Navigation Links
C# Corner Home
Forum Home
Latest 50
Unanswered
Win Prizes
All Time Leaders
Jump to CategoryExpand Jump to Category
Login 
    Welcome Guest!
 Search Forum For :  
X
 Login
Please login to submit a new post, reply and edit exiting posts, see user profiles, and access more features. If you are not a registered member, Register here.
User Id / Email:
Password:  
Forgot Password | Forgot UserName
   Home » SQL Server » How to count number of records
       
Author Reply
suresh
posted 14 posts
since Jan 22, 2008 
from

How to count number of records
  Posted on: 22 Feb 2012       
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,
suresh
venkata saibabu
posted  6 posts
since  Feb 22, 2012 
from 

 Re: How to count number of records
  Posted on: 23 Feb 2012        0  
hi friend you can do write the query in below format : declare @act_date date = '2/2/2012' //login date declare @newact_date date set @newact_date = DATEADD(month, 1, @act_date) select COUNT(@newact_date) where @act_date <=GETDATE() .hope it will be helpful
Deepika Srivastava
posted  6 posts
since  Sep 27, 2011 
from  Pune

 Re: How to count number of records
  Posted on: 23 Feb 2012        0  
Hi Suresh,
Try with the Venkata code. it will give you right o/p.
Thanks, If Helps, please mark it as Answer. !!!
       
Sponsored by
Team Foundation Server Hosting
Become a Sponsor
Our recommended articles
Latest Articles
Nokia 808 PureView
Facebook Killing Innovation
Learn .NET and C# in 60 Days Lab20(Day 10): - Creating a Web application
Working with Arrays in C#
Custom Extension Method to Compare List in C#
Working With Drives and Directories in ASP.NET
Silverlight ListBox Control
SharePoint 2010 - Web Parts Programming
A Walk Through on Windows Azure
Style Element in Metro Apps
View all »
Latest News
Entity Developer with Numerous Enhancements
Windows Phone Ahead Iphone Market in Chaina
DynamicPDF Core Suite v7.0 for .NET Released
C# Corner is hiring iPhone Developers
Windows 8 Release preview will Include Metro Multiple Monitors Improvements
View all »
Latest Blogs
Free Ride is Over for Desktop Developers in Visual Studio 11
DotNet developers most used application/tools launching through 'Run'
80-inch Windows 8 Tablet
Data encapsulation
Option to access the Column Names in Data table
Open multiple windows in browser startup. (Multiple homepages option)
I'm Sorry
const and readonly
Address, Binding and Contract in WCF
JQuery Maxchars Plugin
View all »
Top Articles
Crystal Report in Visual Studio 2010
11 Important Database Designing Rules
Learn .NET in 60 days – Part 1 (13 Labs)
Learn .NET in 60 days - Day 1
Learn MVC (Model view controller) Step by Step in 7 days – Day 3
Learn C# Corner - Home
Learn .NET in 60 days Lab 2 - Day 1
Data Binding in WPF DataGrid Control Using SQL Server Database
Rounded Tab Menu Using jQuery and CSS
Metro UI Guidelines vs Real Windows 8 Metro App
View all »
Free Book Chapters
Chapter 15: Customizing the Display
Chapter 9: OpenType Font Support
Chapter 1: SQL Server 2008 R2 Editions and Enhancements
Chapter 1: Workflow Program
Chapter 7: iNotes and Sametime-Chatting from the Web
Chapter 6: Improving Class Quality
Chapter 12 - Delegates and Lambda Expressions
Chapter 11 - Adding Client Capabilities to Server Controls Using the ASP.NET AJAX Control Toolkit
Chapter 8: C# 4.0 Features
Chapter 2: Creating Versatile Types
View all »
Nevron Gauge for SharePoint
Dynamic PDF
ceTE software specializes in components for dynamic PDF generation and manipulation. The DynamicPDF™ product line allows you to dynamically generate PDF documents, merge PDF documents and new content to existing PDF documents from within your applications. Visit DynamicPDF here
Introducing MaxV - one click. infinite control. Hyper-V Hosting from MaximumASP.
Finally – a virtual platform that delivers next-generation Windows Server 2008 Hyper-V virtualization technology from a managed hosting partner you can truly depend on. Visit www.maximumasp.com/max for a FREE 30 day trial. Hurry offer ends soon. Climb aboard the MaxV platform and take advantage of High Availability, Intelligent Monitoring, Recurrent Backups, and Scalability – with no hassle or hidden fees. As a managed hosting partner focused solely on Microsoft technologies since 2000, MaximumASP is uniquely qualified to provide the superior support that our business is built on. Unparalleled expertise with Microsoft technologies lead to working directly with Microsoft as first to offer IIS 7 and SQL 2008 betas in a hosted environment; partnering in the Go Live Program for Hyper-V; and product co-launches built on WS 2008 with Hyper-V technology.
Nevron Chart for .NET 2010.1 Now Available
The leading .NET charting control now features PDF, Flash and Silverlight export, visualization of large datasets and more. Deliver true charting functionality to your BI, Scorecard, Presentation or Scientific apps. Download evaluation now.
ASP.NET 4 Hosting
Get 2 Months Free of ASP.NET Hosting for Only $4.95/month! Receive FREE MS SQL and MySQL Databases Including ASP.NET 4/3.5, MVC 3.0, Silverlight 4, Windows 2008/IIS 7.0 Plus FREE IIS 7 Modules. Host UNLIMITED ASP.NET Web Sites - Click Here!
Team Foundation Server Hosting
 Hosted by MaximumASP  |  Found a broken link?  |  Contact Us  |  Terms & conditions  |  Privacy Policy  |  Site Map  |  Advertise with us
Current Version: 5.2011.3.12
 © 1999 - 2012  Mindcracker LLC. All Rights Reserved