Description |
Use this script to change SC Product Code "E01" to "E10". Please run this in the RODB.
--script
UPDATE pc
SET pc.strProductCode = 'E10'
FROM tblTFProductCode pc
INNER JOIN tblTFTaxAuthority ta ON pc.intTaxAuthorityId = ta.intTaxAuthorityId
WHERE strTaxAuthorityCode = 'SC' AND pc.strProductCode = 'E01'
|