Archives of the TeradataForum

Message Posted: Thu, 27 Jun 2013 @ 20:15:37 GMT

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

Thx Jim

This following code returned what I was after.

     , (admit_date ?- max(disch_date) over (partition by pt order by admit_date rows
       between 1 preceding and 1 preceding)) disch_admit

best wishes,

jerry

Gerald "Jerry" Fleury
Decision Support

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