Archives of the TeradataForum

Message Posted: Thu, 18 Oct 2007 @ 10:09:37 GMT

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

Hello Shubhangi:

What you could do is use the RANK/OVER function in an INSERT/SELECT to sort the rows of the work table in any order you need and QUALIFY them so that all rows with a value of 1 is inserted into the target table. Than you could go back and do a join or subquery using the target table to delete these inserted rows from the work table - hence your work table becomes your error table.

Just a thought,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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