I have an SQL store procedure that is being crazy for lack of better words. I doesn't seem to matter how I structure the joins, certain rows are being repeated a couple hundred times. Originally the stored procedure utilized all LEFT JOIN, however, I've been attempting to get this working by using a mixture of INNER and LEFT JOIN. Entries that are listed as HOURS will and an IndID, Expenses will have an IndID of -1. The repeated issue you will observe the 425508 TimeCardID repeating.Please find attached the SP and screenshot.spr_payroll.txt
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.