SELECT code, eai_name FROM tbl_PRD_MemoTypes DELETE tbl_IMPORT_ProductDataMemo WHERE eai_batchID = AND linkType = 'SKU'; INSERT INTO tbl_IMPORT_ProductDataMemo(eai_batchid, linkid, linkType, memoType, memoData, dataAction) SELECT #attributes.batchid#, p.sku_skuid, 'SKU', '#qry_MemoColumns.code#', #qry_MemoColumns.eai_name# , dataAction = CASE WHEN md.linkid IS NULL THEN 'INSERT' ELSE 'UPDATE' END FROM tbl_IMPORT_ProductData p LEFT OUTER JOIN tbl_PRD_Memo md ON (p.sku_skuid = md.linkid AND md.linkType = 'SKU' AND md.memoType = '#qry_MemoColumns.code#' AND md.ownerid = #attributes.ownerid# AND md.fsl_TableCode = '#attributes.ownerType#' ) WHERE p.eai_batchID = AND len(cast(#qry_MemoColumns.eai_name# as varchar(8000))) > 0 AND p.sku_skuid IS NOT NULL AND p.sku_processAction <> 'INACTIVE' DELETE memo FROM tbl_PRD_Memo memo INNER JOIN tbl_PRD_SKUS s ON (s.skuid = memo.linkid AND memo.linkType = 'SKU') INNER JOIN tbl_IMPORT_ProductData p ON (s.sku = p.sku_sku) WHERE memo.ownerid = AND memo.fsl_tableCode = AND memo.linkType = 'SKU' AND p.eai_batchID = AND p.sku_processAction <> 'INACTIVE' INSERT tbl_PRD_Memo(ownerid, fsl_tableCode, linkid, linkType, memoType, memoData) SELECT #attributes.ownerid#, '#attributes.ownerType#', linkid, 'SKU', memoType, memoData FROM tbl_IMPORT_ProductDataMemo WHERE eai_batchID = INSERT tbl_PRD_Memo(ownerid, fsl_tableCode, linkid, linkType, memoType, memoData) SELECT #attributes.ownerid#, '#attributes.ownerType#', linkid, 'SKU', memoType, memoData FROM tbl_IMPORT_ProductDataMemo WHERE eai_batchID = AND dataAction = 'INSERT'; UPDATE memo SET memo.memoData = pdm.memoData FROM tbl_IMPORT_ProductDataMemo pdm INNER JOIN tbl_PRD_Memo memo ON (pdm.linkid = memo.linkid AND memo.linkType = 'SKU' AND pdm.memoType = memo.memoType) WHERE eai_batchID = AND memo.ownerid = AND memo.fsl_tableCode = AND pdm.dataAction = 'UPDATE'; DELETE memo FROM tbl_PRD_Memo memo WHERE memo.ownerid = AND memo.fsl_tableCode = AND memo.linkType = 'SKU' AND memo.LinkID IN (select stage.linkid from tbl_IMPORT_ProductDataMemo stage where stage.eai_batchid = and stage.linkType = 'SKU') --->