Archives of the TeradataForum

Message Posted: Wed, 04 Feb 2004 @ 12:47:25 GMT

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

Hi Pratibha,

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
 ;

Cheers,

Tris Bayliff.

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