rfc-bad-priority.txt

/* Off in its own RC SQL Execute
SELECT PRIORITY_ID,REF_ID
  FROM CCM_CHANGES
  WHERE PRIORITY_ID = '32798'
  ORDER BY REF_ID
*/
/* Off in its own SM SQL Execute
SELECT NUMBER,CURRENT_PHASE,PRIORITY_CODE
  FROM CM3RM1
  WHERE PRIORITY_CODE <> '1' AND PRIORITY_CODE <> '2' AND PRIORITY_CODE <> '3'  
*/
/*----------------------------------------*/
DECLARE @BadNum varchar(30) , @Priority char(1)  
SET @Priority = '1'
SET @BadNum   = 'CM0001716'
/*

*/
/*----------------------------------------*/

SELECT NUMBER,PRIORITY_CODE FROM CM3RM1   WHERE NUMBER = @BadNum
UPDATE CM3RM1 SET PRIORITY_CODE = @Priority WHERE NUMBER = @BadNum
SELECT NUMBER,PRIORITY_CODE FROM CM3RM1   WHERE NUMBER = @BadNum

SELECT NUMBER,SYSMODTIME FROM CM3RM2   WHERE NUMBER = @BadNum
UPDATE CM3RM2 SET SYSMODTIME = GETDATE() WHERE NUMBER = @BadNum
SELECT NUMBER,SYSMODTIME FROM CM3RM2   WHERE NUMBER = @BadNum