I have already implemented your suggestion about the .999 seconds in the the date. Since the column that the case statement is based on is the same as my group by column I don't think it matters if I use the column name or the full case statement.