Archives of the TeradataForum

Message Posted: Wed, 04 Feb 2004 @ 13:53:23 GMT

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

Pratibha,

heres one way to do it :

SEL  A.GIVEN_DATE,
     B.CALENDAR_DATE,
        .
        .
        .

FROM TABLE_1 A,  SYS_CALENDAR.CALENDAR B

WHERE B.DAY_OF_WEEK = 7
AND   B.CALENDAR_DATE BETWEEN A.GIVEN_DATE AND A.GIVEN_DATE + 6
AND [other criteria]

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