SELECT tmp.eai_lineNumber, tmp.sku_sku, tmp.sku_skuid, tmp.custom_1, tmp.custom_2, tmp.custom_3, tmp.custom_4, tmp.custom_5, tmp.custom_6, CAST(tmp.custom_5 as date) startdate, CAST(tmp.custom_6 as date) enddate, tmp.custom_10, custom_12, custom_13, custom_8, opr.companyname, custom_14, sku_mfrid, coalesce(m.mfr_name, 'Unknown') mfr_name FROM tbl_IMPORT_ProductData tmp LEFT OUTER JOIN tbl_OPR_ClientOperators opr ON CAST(tmp.custom_10 AS int) = opr.operatorid LEFT OUTER JOIN tblManufacturers m with (nolock) on tmp.sku_mfrid = m.mfr_id WHERE tmp.eai_batchid = SELECT eai_lineNumber FROM qry_getdata WHERE custom_14 = 'UPDATED' SELECT eai_lineNumber FROM qry_getdata WHERE custom_14 = 'ADDED' SELECT eai_lineNumber FROM qry_getdata WHERE custom_14 = 'SKIPPED' OR custom_12 = 'Invalid' SELECT * FROM qry_getdata WHERE custom_12 = 'Invalid' ORDER BY mfr_name, custom_13, companyname, sku_sku SELECT * FROM qry_getdata WHERE custom_14 = 'ADDED' ORDER BY mfr_name, custom_13, companyname, sku_sku SELECT * FROM qry_getdata WHERE custom_14 = 'UPDATED' ORDER BY mfr_name, custom_13, companyname, sku_sku SELECT * FROM qry_getdata WHERE custom_14 = 'SKIPPED' ORDER BY mfr_name, custom_13, companyname, sku_sku SELECT * FROM qry_getdata WHERE sku_mfrid IS NULL
SPECIFIED SKU SUMMARY
Message Detail
BatchID #attributes.batchid#
Batch Date #dateformat(qmd_batch.batchtime,"mm-dd-yyyy")# #timeformat(qmd_batch.batchtime,"hh:mm tt")#
Client Name #variables.ClientName#
Total Rows Processed #numberformat(val(qry_getdata.recordCount))#
Rows Purged #numberformat(variables.PurgedRecords)#
Rows Added #numberformat(val(qofq_Added.recordCount))#
Rows Updated #numberformat(val(qofq_Inserted.recordCount))#
Rows Skipped #numberformat(val(qofq_Skipped.recordCount))#

DUPLICATES
Duplicated Rows: #numberformat(variables.DuplicateRecords)#
The duplicated rows have been removed!

EXCEPTIONS
MFR Sku Customer Sku Customer ID Operator Error
#htmleditFormat(qofq_Exceptions.mfr_name)#
#qofq_Exceptions.sku_sku# #qofq_Exceptions.custom_1# #qofq_Exceptions.custom_3# #qofq_Exceptions.companyname# (OperatorID:#qofq_Exceptions.custom_10#) #qofq_Exceptions.custom_13#
#htmleditFormat(qofq_NoMfr.mfr_name)#
#qofq_NoMfr.custom_8# #qofq_NoMfr.sku_sku#
None

EXCEPTIONS - INVALID MANUFACTURER CODE
MFR Name Sku
#htmlEditFormat(qofq_NoMfr.mfr_name)#
#qofq_NoMfr.custom_8# #qofq_NoMfr.sku_sku#
None

ADDITIONS
MFR Sku Customer Sku Customer ID Operator Status Start End Action
#htmlEditFormat(qofq_InsertedSum.mfr_name)#
#qofq_InsertedSum.sku_sku# #qofq_InsertedSum.custom_1# #qofq_InsertedSum.custom_3# #qofq_InsertedSum.companyname# #qofq_InsertedSum.custom_4# #qofq_InsertedSum.custom_5# #qofq_InsertedSum.custom_6# #qofq_InsertedSum.custom_14#
None

UPDATES
MFR Sku Customer Sku Customer ID Operator Status Start End Action
#htmlEditFormat(qofq_UpdatedSum.mfr_name)#
#qofq_UpdatedSum.sku_sku# #qofq_UpdatedSum.custom_1# #qofq_UpdatedSum.custom_3# #qofq_UpdatedSum.companyname# #qofq_UpdatedSum.custom_4# #qofq_UpdatedSum.custom_5# #qofq_UpdatedSum.custom_6# #qofq_UpdatedSum.custom_14#
None
SKIPPED ROWS
MFR Sku Customer Sku Customer ID Operator Action
#htmleditFormat(qofq_SkippedSum.mfr_name)#
#qofq_SkippedSum.sku_sku# #qofq_SkippedSum.custom_1# #qofq_SkippedSum.custom_3# #qofq_SkippedSum.companyname# #qofq_SkippedSum.custom_14#
None