sm-new-stale-removal.txt


/*  
  WHERE [OPEN] = 't' AND CURRENT_PHASE = 'New' AND ORIG_DATE_ENTERED < DATEADD(d , -30, GETDATE()) AND PLANNED_START < GETDATE()
  WHERE [OPEN] = 't' AND CURRENT_PHASE = 'New' AND ORIG_DATE_ENTERED < DATEADD(d , -30, GETDATE()) AND (PLANNED_START < GETDATE() OR PLANNED_START IS NULL)
  WHERE [OPEN] = 't' AND CURRENT_PHASE = 'New' AND ORIG_DATE_ENTERED < DATEADD(d , -30, GETDATE()) AND (PLANNED_START >= GETDATE() OR PLANNED_START IS NULL)
  WHERE [OPEN] = 't' AND CURRENT_PHASE = 'New' AND ORIG_DATE_ENTERED < DATEADD(d , -30, GETDATE()) AND PLANNED_START IS NULL
  WHERE [OPEN] = 't' AND CURRENT_PHASE = 'New' AND ORIG_DATE_ENTERED < DATEADD(d , -30, GETDATE()) AND PLANNED_START <= GETDATE()
  WHERE [OPEN] = 't' AND CURRENT_PHASE = 'New' AND ORIG_DATE_ENTERED < DATEADD(d , -30, GETDATE()) AND (PLANNED_START IS NULL OR PLANNED_START <= GETDATE())
  ORDER BY PLANNED_START
  ORDER BY NUMBER

DECLARE @MyRFC varchar(20) ; SET @MyRFC = 'CM0004947'

SELECT NUMBER,CURRENT_PHASE,ORIG_DATE_ENTERED
  FROM CM3RM1
  WHERE NUMBER = @MyRFC

SELECT NUMBER
  FROM CM3RM2
  WHERE NUMBER = @MyRFC

SELECT NUMBER
  FROM CM3RA1
  WHERE NUMBER = @MyRFC

SELECT NUMBER
  FROM CM3RA2
  WHERE NUMBER = @MyRFC
*/

SELECT NUMBER,CURRENT_PHASE,ORIG_DATE_ENTERED,PLANNED_START,[OPEN]
  FROM CM3RM1
  WHERE [OPEN] = 't' AND CURRENT_PHASE = 'New' AND ORIG_DATE_ENTERED < DATEADD(d , -30, GETDATE()) AND (PLANNED_START IS NULL OR PLANNED_START <= GETDATE())
  ORDER BY NUMBER