>
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? >
>I'm about to generate a test script....
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham