Archives of the TeradataForum

Message Posted: Wed, 07 Mar 2012 @ 21:38:53 GMT

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

Not that I know but I would UPSERT was the most common method of "Update if record exists else insert if it does not" but if you want two separate tables you could look at insert via a View that joins two tables or simply run two inserts: Insert into t1... from S1.. where ... followed by Insert into t2 ... from S1... where in (sel ... from S1... minus ... t1)

Kenneth Hansen

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