INSERT INTO tbl_PRD_Packaging(LinkID, linkType, OwnerId, FSL_TableCode) SELECT p.sku_skuid AS linkID, '#attributes.catalogLevel#', #attributes.ownerid#, '#attributes.ownerType#' FROM tbl_IMPORT_Productdata p LEFT OUTER JOIN tbl_PRD_packaging pk ON (pk.linkid = p.sku_skuid AND pk.ownerid = AND pk.fsl_tableCode = AND pk.linkType = ) WHERE eai_batchid = AND pk.linkid IS NULL AND p.sku_skuid IS NOT NULL UPDATE pkg SET pkg.DATE_STAMP = getDate(), pkg.CAT_NUM = p.pkg_CAT_NUM, pkg.CLASS_NUM = p.pkg_CLASS_NUM, pkg.SCC14 = p.pkg_SCC14, pkg.UPC = p.pkg_UPC, pkg.MASTER_UNIT_QTY = p.pkg_MASTER_UNIT_QTY, pkg.MASTER_UNIT_SIZE = p.pkg_MASTER_UNIT_SIZE, pkg.MASTER_UNIT_DESC = p.pkg_MASTER_UNIT_DESC, pkg.MASTER_UNIT_SIZE_DESC = p.pkg_MASTER_UNIT_SIZE_DESC, pkg.MASTER_UNIT_SIZE_MEASURE = p.pkg_MASTER_UNIT_SIZE_MEASURE, pkg.MASTER_PACK = p.pkg_MASTER_PACK, pkg.MASTER_GROSS_WEIGHT = p.pkg_MASTER_GROSS_WEIGHT, pkg.MASTER_GROSS_WEIGHT_UNIT = p.pkg_MASTER_GROSS_WEIGHT_UNIT, pkg.MASTER_NET_WEIGHT = p.pkg_MASTER_NET_WEIGHT, pkg.MASTER_NET_WEIGHT_UNIT = p.pkg_MASTER_NET_WEIGHT_UNIT, pkg.MASTER_HEIGHT = p.pkg_MASTER_HEIGHT, pkg.MASTER_HEIGHT_UNIT = p.pkg_MASTER_HEIGHT_UNIT, pkg.MASTER_WIDTH = p.pkg_MASTER_WIDTH, pkg.MASTER_WIDTH_UNIT = p.pkg_MASTER_WIDTH_UNIT, pkg.MASTER_LENGTH = p.pkg_MASTER_LENGTH, pkg.MASTER_LENGTH_UNIT = p.pkg_MASTER_LENGTH_UNIT, pkg.MASTER_CUBE = p.pkg_MASTER_CUBE, pkg.MASTER_CUBE_UNIT = p.pkg_MASTER_CUBE_UNIT, pkg.KOSHER = p.pkg_KOSHER, pkg.KOSHER_COMMENTS = p.pkg_KOSHER_COMMENTS, pkg.CATCH_WEIGHT = p.pkg_CATCH_WEIGHT, pkg.STORAGE_TEMP = p.pkg_STORAGE_TEMP, pkg.STORAGE_TEMP_UNIT = p.pkg_STORAGE_TEMP_UNIT, pkg.SHELF_LIFE = p.pkg_SHELF_LIFE, pkg.SHELF_LIFE_AMBIENT = p.pkg_SHELF_LIFE_AMBIENT, pkg.SHELF_LIFE_REFRIG = p.pkg_SHELF_LIFE_REFRIG, pkg.SHELF_LIFE_FROZEN = p.pkg_SHELF_LIFE_FROZEN, pkg.SERVINGS_PER_CASE = p.pkg_SERVINGS_PER_CASE, pkg.SERVING_SIZE = p.pkg_SERVING_SIZE, pkg.SUB_MASTER_UNIT_QTY = p.pkg_SUB_MASTER_UNIT_QTY, pkg.SUB_MASTER_UNIT_DESC = p.pkg_SUB_MASTER_UNIT_DESC, pkg.SUB_MASTER_UNIT_SIZE = p.pkg_SUB_MASTER_UNIT_SIZE, pkg.SUB_MASTER_UNIT_SIZE_MEASURE = p.pkg_SUB_MASTER_UNIT_SIZE_MEASURE, pkg.SUB_MASTER_UNIT_SIZE_DESC = p.pkg_SUB_MASTER_UNIT_SIZE_DESC, pkg.PALLET_TIE = p.pkg_PALLET_TIE, pkg.PRODUCT_STABILITY = p.pkg_PRODUCT_STABILITY, pkg.PALLET_HIGH = p.pkg_PALLET_HIGH, pkg.PALLET_EXTRA = p.pkg_PALLET_EXTRA, pkg.TOTAL_PALLET = p.pkg_TOTAL_PALLET FROM tbl_PRD_Packaging pkg INNER JOIN tbl_IMPORT_ProductData p ON (pkg.linkid = p.sku_skuid) WHERE p.eai_batchid = AND pkg.OwnerID = AND pkg.FSL_TableCode = AND pkg.linkType = AND p.sku_skuid IS NOT NULL AND coalesce(p.sku_processAction,'') IN ('UPDATED','ADDED')