Archives of the TeradataForum

Message Posted: Tue, 09 Nov 2010 @ 14:32:42 GMT

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

How about:

     Sel member_id, case when add_months(mindate, 12) - maxdate  >=0 then 'Yes'
     else 'No' end
     (
     Sel member_id, max(date_admitted) maxdate, min(date_admitted) mindate
     >From t1
     Group by 1
     )derv ;

     (Not tested).

Regards,

Sivaji GV
DWSDBA

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