Just a follow up question, please. I like the second solution (using Cast) better because it eliminates need for Time consideration. Do I understand correctly that the performance hit is on the server where SQL Server has to Cast (convert) each row's value from DateTime to Date? If so, how much of an impact you think it will have on a table, say, of about 100,000 rows? Seconds? Minutes?
