UPDATE p SET pkg_DATE_STAMP = FROM tbl_IMPORT_ProductData p WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid = AND (nullif(pkg_DATE_STAMP,'') IS NULL); UPDATE p SET cat_publishdate = , cat_unpublishdate = FROM tbl_IMPORT_ProductData p WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid = AND (nullif(cat_publishdate,'') IS NULL); UPDATE p SET prod_publishdate = , prod_unpublishdate = FROM tbl_IMPORT_ProductData p WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid = AND (nullif(prod_publishdate,'') IS NULL); UPDATE p SET sku_publishdate = , sku_unpublishdate = , sku_lastUpdate = FROM tbl_IMPORT_ProductData p WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid = --AND (nullif(sku_publishdate,'') IS NULL); UPDATE p SET prod_mfrid = , sku_mfrid = FROM tbl_IMPORT_ProductData p WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid = UPDATE p SET mfrPrdLn_ProdLine_ID = 0, cat_ProdLineID = 0 FROM tbl_IMPORT_ProductData p WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid = AND nullif(p.cat_catnum,'') IS NOT NULL AND mfrPrdLn_ProdLine_ID IS NULL; UPDATE p SET mfrPrdLn_processaction = null, mrfBrnd_processaction = null, cat_processaction = null, prod_processAction = null, sku_processaction = null FROM tbl_IMPORT_ProductData p WHERE p.ownerType = AND p.ownerId = AND p.eai_batchid =