select fmt.ownerId, fmt.ownerType, fmt.formatId, fmt.formatname, fld.fieldId, fld.fieldName, fld.stagingColumn, fld.usageComments, fieldFormatRegEx, fld.stagingColumnSave, fld.usageCommentsSave from tbl_EAI_inboundFileFormatFields fld inner join tbl_EAI_inboundFileFormats fmt on fmt.formatId = fld.formatId where fld.stagingColumn = 'uom' and fmt.formatName like 'TPM_PROOF_OF_DELIVERY%' order by fmt.ownerId, fmt.ownerType, fmt.formatId update tbl_EAI_inboundFileFormatFields set fieldFormatRegEx = , usageComments = where formatId = and fieldId = update tbl_EAI_inboundFileFormatFields set fieldFormatRegEx = null, stagingColumn = 'void', usageComments = 'ignored' where formatId = and fieldId = update tbl_EAI_inboundFileFormatFields set fieldFormatRegEx = , usageComments = where formatId = and fieldId = update tbl_EAI_inboundFileFormatFields set stagingColumnSave = , usageCommentsSave = where formatId = and fieldId = and stagingColumnSave is null select fmt.ownerId, fmt.ownerType, fmt.formatId, fmt.formatname, fld.fieldId, fld.fieldName, fld.stagingColumn, fld.usageComments, fieldFormatRegEx, fld.stagingColumnSave, fld.usageCommentsSave from tbl_EAI_inboundFileFormatFields fld inner join tbl_EAI_inboundFileFormats fmt on fmt.formatId = fld.formatId where fld.fieldId in ( ) order by fmt.ownerId, fmt.ownerType, fmt.formatId select ownerId, ownerType, itemUOM, itemUOMSave, count(*) lineCount from tbl_TPM_ProofOfDelivery with (nolock) where ( nullif( itemUOM, '' ) is not null or nullif( itemUOMSave, '' ) is not null ) and ownerId > 0 and ownerType = 'MFR' group by ownerId, ownerType, itemUOM, itemUOMSave update tbl_TPM_proofOfDelivery set itemUOM = null, itemUOMSave = where ownerId = and ownerType = and itemUOM = update tbl_TPM_proofOfDelivery set itemUOM = null, itemUOMSave = where ownerId = and ownerType = and itemUOM = select ( select mfr_name from tblManufacturers where mfr_id = ownerId ) as Manufacturer, itemUOM, itemUOMSave, count(*) ePODlineCount from tbl_TPM_ProofOfDelivery with (nolock) where ( nullif( itemUOM, '' ) is not null or nullif( itemUOMSave, '' ) is not null ) and ownerId > 0 and ownerType = 'MFR' group by ownerId, itemUOM, itemUOMSave order by Manufacturer select ( select mfr_name from tblManufacturers where mfr_id = ownerId ) as Manufacturer, itemUOMSave badUOM, count(*) ePODlineCount from tbl_TPM_ProofOfDelivery with (nolock) where nullif( itemUOMSave, '' ) is not null and ownerId > 0 and ownerType = 'MFR' group by ownerId, itemUOMSave order by Manufacturer

Changes Rolled Back

Changes Committed