query to find Saturday/Sundays

arnabghosh · July 10th, 2006, 07:37 AM

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

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

Pls help

SqlMenace · July 10th, 2006, 07:49 AM

One way

select count(*)
from table
where DateColumn between '20060701' and '20060831'
and datepart(dw,DateColumn) in (1,7)

------------------------------------------ http://sqlservercode.blogspot.com/

arnabghosh · July 10th, 2006, 08:01 AM

Hi,
Thanks for your help but I do not have any table to store the datas for all the days in a month.What would be the query for system date..

Arnab

arnabghosh · July 10th, 2006, 08:35 AM

Hi,
Also date range is stored in 2 columns startdate and enddate now can the query be formed...Pls help I'm in a soup.

arnabghosh · July 10th, 2006, 08:37 AM

Hi,
I ran the query but it did not return any result.
pls can anyone help.

Peso · July 10th, 2006, 01:22 PM

I have written an article about this at http://www.sqlservercentral.com/colu...tiliretire.asp

Also see this topic http://p2p.wrox.com/topic.asp?TOPIC_ID=46835

arnabghosh · July 11th, 2006, 02:17 AM

Thanks Peso for your great help!!!!

robprell · July 15th, 2006, 12:44 AM

I prefer to do this with a table that contains dates. You populate it with one row for every day in the date range your dealing with. Thus a simple query using a count and a where >= x date and <= y date and dayofweek = ??? you get your results.