Use Teradata Recursions to build a Calendar

At times we need to join records in one table with a specified range of dates in a second table. One application which comes to my mind in the first place is to fake a snapshot history table (containing a snapshot date) based on a change history table (containing timelines limited by a start date and … Continue reading Use Teradata Recursions to build a Calendar