Archives of the TeradataForum

Message Posted: Thu, 15 Dec 2011 @ 13:49:27 GMT

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

Ok thanks my goal here is T1.ACIN1 is going to be constantly changed So whenever there is a change on T1.ACIN1. Then the old record in T1.ACIN1 Move to T1.ACIN2, then T1.ACIN2 move to T1.ACIN3 and T1.ACIN3 move to T1.ACIN4 when it reaches the final Point I guess we have to keep going instead of returning to T1.ACIN3. The logical model does not make sense here.

I will look into it.

Thanks all of you for your quick respond. I think I need to do more reading.

Can you please give the full syntax of SELECT COUNT(*) FROM (SELECT DISTINCT...) x;

Thanks

Gabriel Issah

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