Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 04 Jan 2001 @ 20:02:02 GMT

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

Subj:   Re: System Calendar
From:   Warren Gilbert

We use our own Calendar table and our financial years are as you describe.

When we upgraded to V2.R3, I created a view through the System Calendar to mirror the table. From memory (I am writing from home, not from work), the view contained the start date for each year, used in a case statement.

The view produced the same data as the table, but with a few experiments, did not perform as well as the table, and was not pursued. This may have been due to the difference in the number of rows in the tables, our table being limited to a range of less than10 years.


  <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: 28 Jun 2020