rc-bad-user-email.txt

/*----------------------------------------*/
DECLARE @CurNam varchar(64) , @Email varchar(128) , @LogNam varchar(64) , @BizID varchar(64)  , @First varchar(64) , @Last varchar(64)
/*------------------------------------------------------------------------------
Ricketts, Joel      jxricketts         ricketts.joel@con-way.com
Wilson, Kimberly    kjwilson           wilson.kimberly@con-way.com
Trinidad, Reynaldo  trinidad.reynaldo  trinidad.reynaldo@con-way.com
Maxwell, Terry      maxwell.terry      maxwell.terry@con-way.com
Ku, Mark            ku.mark            ku.mark@con-way.com

-Deleted User-9999  ?                   rc.deleted@con-way.com

SET @CurNam    = ''
SET @NewNam    = ''
SET @NewEmail  = ''

SELECT * FROM CCM_USERS
  WHERE EMAIL IS NULL  AND LOGIN_NAME NOT LIKE '-Deleted User%'

SELECT * FROM CCM_USERS
  WHERE EMAIL ='' AND LOGIN_NAME NOT LIKE '-Deleted User%'

SELECT * FROM CCM_USERS
  WHERE EMAIL IS NULL  AND LOGIN_NAME NOT LIKE '-Deleted User%'

SET @NewNam    = 'Ku, Mark'
SET @CurNam    = 'ku.mark'
SET @NewEmail  = 'ku.mark@con-way.com'

UPDATE CCM_USERS
   SET LOGIN_NAME = @NewNam
      ,EMAIL      = @NewEmail
      ,FIRST_NAME = @NewNam
      ,LAST_NAME  = @NewNam
   WHERE LOGIN_NAME = @CurNam

SELECT * FROM CCM_USERS
  WHERE LOGIN_NAME = @NewNam

SELECT * FROM CCM_USERS
 WHERE EMAIL IS NULL AND LOGIN_NAME NOT LIKE '-Deleted User%'
 WHERE LOGIN_NAME LIKE '-Deleted User%'
 ORDER BY EMAIL

SET @NewNam    = 'Bjorn, Jeanne'
SET @CurNam    = 'bjorn.jeanne'
SET @NewEmail  = 'bjorn.jeanne@con-way.com'

SELECT * FROM CCM_USERS
 WHERE LOGIN_NAME = @CurNam

UPDATE CCM_USERS
   SET LOGIN_NAME  = @LogNam
      ,BUSINESS_ID = @BizID
      ,FIRST_NAME  = @First
      ,LAST_NAME   = @Last
      ,EMAIL       = @Email
   WHERE LOGIN_NAME = @CurNam

SELECT * FROM CCM_USERS
 WHERE LOGIN_NAME = @NewNam
 WHERE LOGIN_NAME LIKE 'bj%'
------------------------------------------------------------------------------*/

SET @CurNam = 'pxnelson'
SET @LogNam = 'pxnelson'
SET @BizID  = 'pxnelson'
SET @First  = 'Patrick'
SET @Last   = 'Nelson'
SET @Email  = 'nelson.patrick@con-way.com'

SELECT * FROM CCM_USERS
   WHERE LOGIN_NAME = @CurNam

UPDATE CCM_USERS
   SET LOGIN_NAME  = @LogNam
      ,BUSINESS_ID = @BizID
      ,FIRST_NAME  = @First
      ,LAST_NAME   = @Last
      ,EMAIL       = @Email
   WHERE LOGIN_NAME = @CurNam

SELECT * FROM CCM_USERS
   WHERE LOGIN_NAME = @LogNam