rc-cag-set1.txt


CREATE TABLE #CAG
(
  OldCAG varchar(64),
  NewCAG varchar(64),
  NewEDL varchar(128)
)

INSERT INTO #CAG (OldCAG , NewCAG , NewEDL) VALUES ('CA - EBI-Core Team Notifications' , 'CA - EBI Change Approvers' , 'caebicoreteamnotifications@con-way.com'          )

SELECT * FROM #CAG

UPDATE CCM_USERS
SET EMAIL       = cag.NewEDL
   ,FIRST_NAME  = cag.NewCAG
   ,LAST_NAME   = cag.NewCAG
   ,LOGIN_NAME  = cag.NewCAG
   ,BUSINESS_ID = cag.NewCAG
FROM #CAG cag
  INNER JOIN CCM_USERS ccm
    ON ccm.LOGIN_NAME = cag.OldCAG

SELECT * FROM CCM_USERS
  WHERE LOGIN_NAME like 'CA - EBI %'