Archives of the TeradataForum

Message Posted: Fri, 06 Aug 2004 @ 09:41:00 GMT

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

Hi,

You can have a log table with Columns like RunID, TableName, StartTime, EndTime, ElapsedTime, RowsAffected .Before Insert Query, Insert a new record into the Logtable leaving the EndTime, ElapsedTime and RowsAffected (Will be RowCount before inserting into that table). After the Insert Query Update the Endtime, Elapsed Time and RowsAffected.

Regards,

Prasanna.

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