Thank you so much that worked!!

Thank you all. Appreciate all of your knowledge. Thanks again!

Thanks to everyone for their help! Just learned a heck of a lot. Thanks again!

Here is what I have so far.

Select person.id as ID_Number,lastname,firstname, count(datediff(day,jobstartdate,jobenddate)) as Absent_Count

from Person

inner join job

on person.id =job.employeeid

where purgeid = 0

group by Id_Number, lastname, firstname

order by ID_Number asc

Thank you both worked great!

Jeff Moden (12/26/2010)

---

pkaraffa (12/26/2010)

---

Thanks andrewd.smith that worked very well for a small amount of data (actually great) but I am dealing with over 500,000 rows and about a thousand different...

Thanks andrewd.smith that worked very well for a small amount of data (actually great) but I am dealing with over 500,000 rows and about a thousand different dates. LutzM I...

Old Hand

That is it thank you both so much! I appreciate all of the help and guidance that you have given me!

Thanks you so much for responding. That is close but the attendace table has true and false in which when I run the first statement it will give me something...