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.
Unless the datetime column you're reading contains a date matching DATEADD(day, 1 @YourEndDate) without the time, in which case it'll include the row when it shouldn't. You'll have to use < instead of <=.