How does using the min/max work for you when you have multiple records for a single employee of multiple dates?

Sample data and expected results based on that data will go a long way in helping us help you.

Actually, we need more information from teh OP. If we could get the DDL (CREATE TABLE statements) for the source and target tables, sample data for the source table,...

Two things to start. How do you know which record is the "clock in" and which is the "clock out"? You appear to have a possible data problem...

The answer is simple, it depends. Each query is an answer to a different question. Without knowing the question, we can't tell you if the query is correct...

What is the with the division? The question was to display the age in days:

datediff(dd, dob, getdate())) -- How many days between now...

Can't from work and the evenings are busy doing other stuff.

CirquedeSQLeil (1/21/2011)

---

Lynn Pettis (1/21/2011)

---

CirquedeSQLeil (1/21/2011)

---

Lynn Pettis (1/20/2011)

---

If you took the time to do a little research in Books Online, you would probably have been able to figure this one out...

CirquedeSQLeil (1/21/2011)

---

There...

Stefan Krzywicki (1/20/2011)

---

Lynn Pettis (1/20/2011)

---

Just a follow-up. I will now be spending one or more hours moving a column back to its original position in the row...

This is actually quite simple, unfortunately I can't help you as you haven't provided the DDL (CREATE TABLE statements) for the tables involved, sample data for the tables to test...

I know it has been awhile, but were you able to solve your problem?

If it isn't a true backup, but a file backup, you may not be able to do anything. If SQL Server was down while the file backup is run,...

I have to concur with Jason having heard your presentation at the CSSUG meeting a couple of years ago.

Not sure you can get what you want without capturing the history of the changes. You need to capture the changes as they occur in a history table of...