Archives of the TeradataForum

Message Posted: Tue, 10 May 2005 @ 21:17:13 GMT

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

try -

     UPDATE SUMMARY_TABLE
        FROM
           (SELECT COUNT(1) CNT
                FROM TABLE_OF_MISMATCHES) VT
          SET TOTAL_COLUMN = VT.CNT ;

Wayne Schachtel
Wayne Schachtel Consulting

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