select datepart( year, invoiceDate ) calendarYear, datepart( week, invoiceDate ) calendarWeek, s.sku, cdr.cdr_dstcode as customer_number, invoiceNumber invoice_number, invoiceDate invoice_date, caseAmt as cases, dollarAmt as dollars, weightAmt as lbs from tbl_CDR_InvoiceHistory ih inner join tbl_CDR_Distributors cdr on cdr.cdr_recordId = ih.cdr_recordId and cdr.ownerId = ih.ownerId and cdr.fsl_tablecode = ih.ownertype inner join tbl_PRD_SKus s on s.skuId = ih.skuId and s.ownerId = ih.ownerId and s.fsl_tablecode = ih.ownerType where ih.ownerId = 26 and ih.ownerType = 'MFR' and datepart( year, invoiceDate ) = 2014 order by calendarYear, calendarWeek, invoice_number select mappingType, fiestaCode, sourceCode from FiestaCodeMapping insert into tbl_IMPORT_InvoiceHistory ( ownerId, ownerType, eai_batchId, eai_lineNumber, customer_number, sku, invoice_date, invoice_number, unit_of_sale, case_qty, extended_price, lb_qty ) values ( 1984, 'MFR', #_batchId#, #_lineNumber#, , , , , 'CSE', , , )