I am importing an appointment schedule from an old software into a new one. I have a situation where I need to seperate out some appointments. Is there any way I can query the appointments table and say something like this:
SELECT * FROM Appointments WHERE DATE is a Tuesday?
This way I'll get all appointments that were scheduled on a Tuesday. And I'll need to do the same for other weekdays as well.
NOTE: I can pull this table into SQL Server 2008 if that makes querying easier.
NOTE: All dates are in the year 2011.