In building a Select-SQL statement, I need the Order By to actaully be ordered by the Month and then Day of a date field similar to:
Order By MONTH(MyTable.HiredDate), DAY(MyTable.HiredDate)
Anyone know how to do something like this?
I would prefer not to have to create a temp index to do this.
Thanks,
Mel Cummings