Avatar of Trent Adams
Trent Adams

asked on 

SQL Query Syntax - Certain Rows Being Returned Multiple Times

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.txtScreen Capture

Avatar of undefined
Last Comment
Trent Adams

8/22/2022 - Mon