Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
|
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 10th, 2006, 06:27 AM
Friend of Wrox
 
Join Date: Apr 2005
Posts: 128
Thanks: 0
Thanked 0 Times in 0 Posts
Default No. of Saturday/Sunday

Hi,
I want to find the count of all the Saturdays & Sundays ia month as well as withinn a date range 01/07/2006 - 31/08/2006


Can this be done with the help of SQL query.???

Pls help
 
Old August 31st, 2006, 11:32 AM
Registered User
 
Join Date: Aug 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I don't understand why you would want to do that in a database.

SQL is there to query a database which has data stored in it. If you want to find out things like that, then I suggest you use some sort of a scripting language, such as ASP.





Similar Threads
Thread Thread Starter Forum Replies Last Post
get the coming saturday date of a given date amlesh SQL Server 2000 10 August 17th, 2007 09:20 AM
getting the second saturday of every month haleem .NET Framework 2.0 1 May 3rd, 2007 12:38 AM
skipping sunday when adding data Vince_421 Access VBA 2 March 6th, 2007 11:22 AM
query to find Saturday/Sundays arnabghosh SQL Server 2000 7 July 15th, 2006 12:44 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.