CREATE PROC spA9T4 AS

BEGIN
            UPDATE tblEmployeeA9
            SET AnnualSalary = ROUND (1.02 * AnnualSalary, -2)IF JobTitle LIKE '%Manager%'
            WHERE Active = 'Y'
END

BEGIN
UPDATE tblEmployeeA9
SET AnnualSalary = ROUND (1.10 * AnnualSalary, -2)IF JobTitle LIKE '%Clerk%' AND JobTitle NOT LIKE '%Manager%'
WHERE Active = 'Y'
END

BEGIN
            UPDATE tblEmployeeA9
            AnnualSalary = ROUND (1.05 * AnnualSalary, -2)IF JobTitle NOT LIKE '%Cleark%' OR JobTitle NOT LIKE '%Manager%'
            WHERE Active = 'Y'
END