Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

Subj:   Re: Insert load half of my data
From:   Issah, Gabriel

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;


Gabriel Issah

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023