Selecting record by day

External Since: Dec 21, 2007 Posts: 2

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?

External Since: Mar 18, 2004 Posts: 317

> 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-...auxilia

--
Dejan Sarka
http://blogs.solidq.com/EN/dsarka/default.aspx