DELETE FROM tbl_TBA_DistributorDataReport SELECT cl.claimID, cl.display_claimid, o.CompanyName, o.MFRCustNum, sum(dd.Quantity) ClaimQty, InvoicePerDesc , DATEDIFF(m,invoiceStart,invoiceEnd)+1 AS Months, month(invoiceStart) AS StartMonth FROM tbl_CDR_Distributors mfrdst INNER JOIN tbl_TBA_Claims cl ON mfrdst.OwnerID = cl.OwnerID AND mfrdst.FSL_TableCode = cl.FSL_TableCode INNER JOIN tbl_TBA_Distributor d INNER JOIN tbl_TBA_DistributorData dd ON d.dst_dataid = dd.dst_dataid ON cl.claimID = d.ClaimID AND mfrdst.cdr_recordid = d.MFR_dstid INNER JOIN tbl_TBA_Contracts c ON cl.ContractID = c.ContractID INNER JOIN tbl_OPR_ClientOperators o ON c.Opr_id = o.OperatorID WHERE cl.OwnerID = AND cl.FSL_TableCode = AND cl.ClaimLevel = 'D' AND year(cl.InvoiceStart) = AND d.CHO_dstid > 0 AND d.FSL_dstid > 0 AND d.MFR_dstid > 0 AND dd.Validated = 1 AND NULLIF(RTRIM(o.MFRCustNum),'') IS NOT NULL AND NULLIF(RTRIM(mfrdst.cdr_dstcode),'') IS NOT NULL GROUP BY cl.claimID, cl.display_claimid, o.CompanyName, o.MFRCustNum, invoiceStart, invoiceEnd, InvoicePerDesc ORDER BY o.CompanyName, invoiceStart INSERT INTO tbl_TBA_DistributorDataReport(claimid, display_claimid, CompanyName, MFRCustNum, InvoicePeriod, dataYear, #monthasString(ListgetAt(_activity[i],1,"|"))# , ) VALUES ( , , , , , , , ) SELECT * FROM tbl_TBA_DistributorDataReport ORDER BY CompanyName, claimid Attached is an excel distributor data summary for #variables.mfrName# #url.rebateYear#