Hello Juan.

Once the file is generated(bcp step is complete), you can run this dos command as next step in the process. This will rename the file, append date to the...

I guess we need a group by on date?

Changed a bit of test data, fixed the checkout times of employee 2 on '3/11/2008'

Create Table Punches(empid int, time_in Datetime, time_out datetime)

insert...

Thanks for the review. I thought no one will bother looking at the query as the original poster was satisfied with Mark's solution.

One of the issues I saw above is...

I changed the test data a bit, My understanding could be wrong here.

SELECT 1,1,getdate() UNION ALL --suspicious entry

SELECT 1,1,getdate() UNION ALL --suspicious entry

SELECT 2,1,getdate() UNION ALL -- Employee 2 Login

SELECT...

A lil change:

Where isnull(a.director, b.director) = b.director