update tblManufacturers set UnitofMeasure = , UnitofMeasurePlural = where mfr_id = update oa set oa.attrDescription = , oa.attrDescriptionPlural = from tbl_ORG_Attributes oa where oa.attrId = and oa.ownerId = and oa.fsl_tablecode = select pp.productStatusId, pp.skuId, pp.prodId, pp.volumeQty from tbl_OPR_ProductStatus pp with (nolock) where pp.ownerId = and pp.ownerType = 'MFR' and mwg is null update tbl_OPR_ProductStatus set volumeQty = , mwg = 1 where productStatusId = and ownerId = and ownerType = 'MFR' select interactionDetailId, saleSubjectType, saleSubjectId, saleQty from tbl_CRM_InteractionSaleDetails with (nolock) where ownerId = and ownerType = 'MFR' and saleSubjectType in ( 'SKU', 'PRD ') and mwg is null update tbl_CRM_InteractionSaleDetails set saleQty = , mwg = 1 where interactionDetailId = and ownerId = and ownerType = 'MFR'