I have tables I need to get combined (SUM of) daily production values on one row for each date to calculate total production for that department for each unique date. My t-SQL code below returns separate rows, as shown in the results that I have pasted below the query.