sm-field-update-02.txt

DECLARE @MyTran varchar(20) ; SET @MyTran = 'pjn01'
/*
SELECT NUMBER,CNF_PLANNED_DAYS
  FROM CM3RM1
  WHERE CNF_PLANNED_DAYS is NULL

SELECT NUMBER,CNF_OWNED_BY,CNF_OWNED_BY_NT
  FROM CM3RM1
  WHERE CNF_OWNED_BY_NT != 'pxnelson' AND CNF_OWNED_BY_NT != 'nelson' 

UPDATE CM3RM1
  SET CNF_PLANNED_DAYS = "0"
  WHERE CNF_PLANNED_DAYS is NULL
UPDATE CM3RM1
   SET CNF_PLANNED_DAYS = '0'
      ,CNF_OWNED_BY = 'nelson, patrick'
      ,CNF_OWNED_BY_NT = 'pxnelson'
  WHERE CNF_OWNED_BY_NT != 'pxnelson' AND CNF_OWNED_BY_NT != 'nelson' 
UPDATE CM3RM1
   SET CNF_OWNED_BY_NT = 'pxnelson'
  WHERE CNF_OWNED_BY_NT = 'nelson' 
UPDATE CM3RM1
   SET CNF_PLANNED_DAYS = '0'
   WHERE CNF_PLANNED_DAYS is NULL

BEGIN TRAN @MyTran
ROLLBACK TRAN @MyTran
COMMIT TRAN @MyTran
*/

SELECT NUMBER,CNF_OWNED_BY,CNF_OWNED_BY_NT,CNF_PLANNED_DAYS
  FROM CM3RM1