Archives of the TeradataForum
Message Posted: Wed, 04 Feb 2004 @ 12:47:25 GMT
joining on match_date to the following code in a view/table should do it.
select a.calendar_date as match_date ,max(b.calendar_date) as weekending_date from sys_calendar.calendar a ,sys_calendar.calendar b where a.week_of_calendar = b.week_of_calendar group by 1 ;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|