Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
select number,hoursperperiod,name,paycode from payrollview.dbo.ppperemployeefile p inner join kronos.dbo.hoursbyday k on k.empnum = p.number inner join payrollview.dbo.ppperemppositionfields e on e.employeeppper = p.employeeppper where (hoursperperiod between '48' and '80') and (date between '01/01/2009' and '06/30/2009') group by number,hoursperperiod,name,paycode order by paycode
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.