Cacher is the code snippet organizer for pro developers

SELECT *
FROM dbo.SecondaryRoleMaster srm --79

SELECT *
FROM [dbo].[RoleStagingTable]

--In SecondaryRoleMaster Replace The SecondaryRole with Mapping PrimaryRole Provided
SELECT srm.NAME AS SecondaryRole, rst.PrimaryRole
FROM dbo.SecondaryRoleMaster srm
INNER JOIN dbo.RoleStagingTable rst ON ltrim(rtrim(upper(srm.NAME))) = ltrim(rtrim(upper(rst.SecondaryRole))) --56
ORDER BY 2


--UPDATE srm
--SET srm.NAME = rst.PrimaryRole
--FROM dbo.SecondaryRoleMaster srm
--INNER JOIN dbo.RoleStagingTable rst ON ltrim(rtrim(upper(srm.NAME))) = ltrim(rtrim(upper(rst.SecondaryRole))) --56

--In Emp_master replace secondary role with primary role mapped to secondary role
SELECT *
FROM dbo.Emp_Master em
INNER JOIN dbo.RoleStagingTable rst ON ltrim(rtrim(upper(em.SecondaryRole))) = ltrim(rtrim(upper(rst.SecondaryRole)))

UPDATE em
SET em.SecondaryRole = rst.PrimaryRole
FROM dbo.Emp_Master em
INNER JOIN dbo.RoleStagingTable rst ON ltrim(rtrim(upper(em.SecondaryRole))) = ltrim(rtrim(upper(rst.SecondaryRole)))