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