rc-user-email.txt

DECLARE @MyTran varchar(20) ; SET @MyTran = 'pjn01'
/*
BEGIN TRAN @MyTran
UPDATE CCM_USERS SET [EMAIL] = 'rc.test@con-way.com' WHERE FIRST_NAME LIKE 'CA -%'AND LOGIN_NAME NOT LIKE '-Deleted%'
UPDATE CCM_USERS SET [EMAIL] = 'rc.test@con-way.com' WHERE FIRST_NAME LIKE 'IT %' AND LOGIN_NAME NOT LIKE '-Deleted%'
UPDATE CCM_USERS SET [EMAIL] = 'rc.deleted@con-way.com' WHERE LOGIN_NAME like '-Deleted%'
UPDATE CCM_USERS SET [EMAIL] = 'rc.unknown.user@con-way.com' WHERE LOGIN_NAME like 'hxkha'
UPDATE CCM_USERS SET [EMAIL] = 'pak.kai@con-way.com' WHERE LOGIN_NAME like 'kypak'
UPDATE CCM_USERS SET EMAIL='pak.kai@con-way.com',FIRST_NAME='Kai',LAST_NAME='Pak' WHERE LOGIN_NAME like 'kypak'
UPDATE CCM_USERS SET [EMAIL] = 'rc.test@con-way.com'
ROLLBACK TRAN @MyTran
COMMIT TRAN @MyTran
*/
SELECT * FROM CCM_USERS 
/* 
 WHERE EMAIL is NULL AND LOGIN_NAME like '-Deleted%' 
 WHERE LOGIN_NAME like '-Deleted%'
 WHERE LOGIN_NAME like '-Deleted%' AND EMAIL like ''
 WHERE EMAIL is NULL OR EMAIL like ''
 WHERE LOGIN_NAME like 'singh.atendra'
 WHERE FIRST_NAME LIKE 'CA -%'AND LOGIN_NAME NOT LIKE '-Deleted%'
 WHERE FIRST_NAME LIKE 'IT %' AND LOGIN_NAME NOT LIKE '-Deleted%'
 WHERE EMAIL LIKE 'nelson.patrick@con-way.com' AND LOGIN_NAME NOT LIKE 'pxnelson' AND LOGIN_NAME NOT LIKE '-Deleted User-%' AND LOGIN_NAME NOT LIKE 'nelson%' AND LOGIN_NAME NOT LIKE 'Service Manager' AND LOGIN_NAME NOT LIKE 'userrc'
 WHERE EMAIL LIKE 'nelson.patrick@con-way.com'
*/

 WHERE EMAIL LIKE 'rc.test@con-way.com'
 ORDER BY LOGIN_NAME