Archives of the TeradataForum

Message Posted: Thu, 08 Nov 2012 @ 13:37:36 GMT

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

Hi Dipti Prakash,

Actaully we can use two differnet ways to generate the sequence number i.e CSUM and RANK as per my knowledge Rank is good for sequence generation...

     INSERT INTO TABLE2
     SELECT RANK() OVER(ORDER BY COLUMN1)+MAX_VAL AS SEQ_NUM
     FROM TABLE1,
     (SELECT COALESCE(MAX(SEQ_NUM),0) MAX_VAL FROM TABLE2) SEQ
     WHERE
     NOT EXISTS
     (SELECT
     1
     FROM
     TABLE2
     WHERE
     TABLE1.COLUMN1=TABLE2.COLUMN1
     )

Regards,

Naresh Neelam

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