sm-planned-start-end.txt

DECLARE @MyTran varchar(20) ; SET @MyTran = 'pjn01'
/*
SELECT NUMBER,PLANNED_START,PLANNED_END
  FROM CM3RM1
  WHERE NUMBER = 'CM0004610'

UPDATE CM3RM1 
  SET PLANNED_START = '2010-07-08 09:00:00.000' ,
      PLANNED_END   = '2010-07-08 10:00:00.000'
  WHERE NUMBER = 'CM0004610'

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

SELECT NUMBER,PLANNED_START,PLANNED_END
  FROM CM3RM1
  WHERE NUMBER = 'CM0004610'