skjoldtc (2/17/2009)
The takeaway is that SQL Server rounds time and don't use BETWEEN with a date range. But, this seems such a strange way to do this. What is the rationale? Can anyone explain that? Do other databases handle time the same way? It seems so counter-intuitive.
My guess is that if you truncated the date, you would not exercise any index on [InsertedOn]. However, IMHBIO (in my humble but inexperienced opinion), I would question the wisdom of indexing a datetime. I stay away from indexing any inexact fields.
Kevin
--
Please upgrade to .sig 2.0