be carefull with datetime and smalldatetime, the later needs only 23:59 because it will include the next day. Read the definitions of datetime fields.

You have to have the group by clause in the insert .. select for it to be correct.