Archives of the TeradataForum

Message Posted: Wed, 07 Nov 2012 @ 16:15:55 GMT

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

     INSERT INTO TargetTable
     SELECT CSUM(1,1)+b.Max_Id
     ...
     FROM SourceTable a
     CROSS JOIN
       (SELECT ZEROIFNULL(MAX(MySurrogate_Id)) as Max_Id
        FROM TargetTable
       ) b

Dirk Anderson

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