PhilPacha (10/21/2014)
Trying to add an arbitrary amount of 'time' to a datetime value which starts out containing ONLY a date is fraught with problems. Try adding the last millisecond or two, for example. The way that is ALWAYS safe is to use >= @YourStartDate and <= DATEADD(DAY, 1, @YourEndDate) as your range.
Ah, be careful now. In most cases, you only want LESS THAN for the end date +1. You also have to make sure that @YourEndDate contains only a midnight time component unless its the DATE datatype.
--Jeff Moden
Change is inevitable... Change for the better is not.