Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 08 Dec 2012 @ 15:57:17 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Can't drop a range of rows
 
From:   Pluebell, Fred

Because weekly intervals don't align with calendar year boundaries.

Your original PI defined weekly ranges

     2009-04-27 to 2009-05-03, 2009-05-04 to 2009-05-10, ...,
     2009-12-28 to 2010-01-03, 2010-01-04 to 2010-01-10, ...,
     2012-12-24 to 2012-12-30, 2012-12-31 to 2012-12-31

In your ALTER DROP RANGE, 2010-01-01 to 2010-01-06 (for example) does not match an existing range.

Also note that your original set of ranges was 192 full weeks plus a final range of only a single day. That works, but introduces some additional complications as far as dropping ranges in the future.



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019