Archives of the TeradataForum

Message Posted: Thu, 15 Mar 2001 @ 17:16:03 GMT

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

It is not ACCESS causing multipler line per each SQL request. I think the fact is that you are logging more than one object: you get one row for each logged object involved in your query.

To eliminate duplicates you could try to group by Logdate, Logtime, SessionNo

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