Selecting record by day

[-]

My table has a datetime column that says when each record was added. How can I
write a SELECT that gives the last record that was added each day?

[Dejan Sarka]

Post by -
My table has a datetime column that says when each record was added. How
can I write a SELECT that gives the last record that was added each day?

Without create table dll, inserts for sample data and desired result it is
hard to give you a quesry that would work for sure. I suggest you to check
if you can get some idea from here:
http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html.