http://skonieczny.pl/2009/05/13/get-beginning-of-the-day-datetime-aka-todays-midnight-in-t-sql/
Get beginning of the day datetime -aka today's midnight - in T-SQL