UPDATE p SET cat_publishdate = dateadd(d,-1,getdate()), cat_unpublishdate = (dateadd(year,10,getdate())) FROM tbl_IMPORT_ProductData p WHERE p.eai_batchid = AND p.sku_skuid IS NOT NULL AND (nullif(cat_publishdate,'') IS NULL) OR (year(cat_publishdate) = 1900); UPDATE p SET prod_publishdate = dateadd(d,-1,getdate()), prod_unpublishdate = (dateadd(year,10,getdate())) FROM tbl_IMPORT_ProductData p WHERE p.eai_batchid = AND p.sku_skuid IS NOT NULL AND (nullif(prod_publishdate,'') IS NULL) OR (year(prod_publishdate) = 1900); UPDATE p SET prod_mfrid = , sku_mfrid = FROM tbl_IMPORT_ProductData p WHERE p.eai_batchid = UPDATE p SET mfrPrdLn_ProdLine_ID = 0, cat_ProdLineID = 0 FROM tbl_IMPORT_ProductData p WHERE p.eai_batchid = AND nullif(p.cat_catnum,'') IS NOT NULL AND mfrPrdLn_ProdLine_ID IS NULL;