Search:  
NamespacesDiscussions.NET v1.1Feedback
How can I return the number of rows that where added during each day for the last 7 days
Messages   Related Types
This message was discovered on ASPFriends.com 'ngfx-sqlclient' list.


Dennis West
How can I return the number of rows that where added during each day for the last 7 days and rename the date to a day name

SQLStatement.Text = "Select Count(*) Create_Date from dwDNS_ where Create_Date < ( Convert(datetime,convert(varchar,getdate(), 1)) ) AND Create_date > (Convert(datetime,convert(varchar,getdate(), 1))-7) order by Create_Date";

For 2002 ASP.NET Solutions & Articles goto:
http://aspalliance.com/dotnetsolutions/

Dennis West
West Design
MS .NET Developer
www. westontheweb.net
Click here to reveal e-mail address
Reply to this message...
 
    
Didier Marin
select count(*) from table
where create_date > dateadd(day, -7, getdate())
group by create_date
-----Original Message-----
From: Dennis West [mailto:Click here to reveal e-mail address]
Sent: Friday, July 19, 2002 5:14 AM
To: ngfx-sqlclient
Subject: [ngfx-sqlclient] How can I return the number of rows that where
added during each day for the last 7 days

How can I return the number of rows that where added during each day for
the last 7 days and rename the date to a day name

SQLStatement.Text = "Select Count(*) Create_Date from dwDNS_ where
Create_Date < ( Convert(datetime,convert(varchar,getdate(), 1)) ) AND
Create_date > (Convert(datetime,convert(varchar,getdate(), 1))-7) order by
Create_Date";

For 2002 ASP.NET Solutions & Articles goto:
http://aspalliance.com/dotnetsolutions/

Dennis West
West Design
MS .NET Developer
www. westontheweb.net
Click here to reveal e-mail address

| [ngfx-sqlclient] member Click here to reveal e-mail address = YOUR ID |
http://www.aspfriends.com/aspfriends/ngfx-sqlclient.asp = JOIN/QUIT
Reply to this message...
 
 




Ad
MBR BootFX
Best-of-breed application framework for .NET projects, developed by Matthew Baxter-Reynolds and MBR IT
 
 Copyright © Matthew Baxter-Reynolds 2001-2008. '.NET 247 Software Development Services' is a trading style of MBR IT Solutions Ltd.
Contact Us - Terms of Use - Privacy Policy - www.dotnet247.com