Wednesday, March 7, 2012

Events Calendar Questions: how to find events in the week end

I have a start date, end date for each event.

I want to list all events between the start and end date comes in Saturday or Sunday.
in SQL server 2005 TSQL statement.

any insights ?Below is a link to an article that explains how to manipulate Dates in SQL and gives a good description of the DATENAME command which you will most likely need to use for this.

http://www.quest-pipelines.com/newsletter-v3/0202_G.htm

I hope that this helps.

No comments:

Post a Comment