If a shift has a start and end time, but there are no invoices matching that shift's User ID, location ID, or shift date, there still needs to be a row created in payroll for that user's shift.
I am having more than 7 years of experience in IT industry.I have worked on .net(c#,asp,asp.net,mvc) with sql server 2005/2008/2012 and oracle(pl/sql).
I can provide you better solution by utilizing my knowledge and skills.