T-SQL Select Date Range
Posted on 2014-03-17
In T-SQL (SQL Server 2000), I am trying to bring back only orders that where purchased during a specified month.
The field that contains the order date is Item_Order_Date and the date is specified as:
For example if I wanted to select the orders that were done in March, but going back to prior years as well.
I only want to filter on the the month value. Any ideas? Thanks