Archives of the TeradataForum

Message Posted: Tue, 03 Aug 2004 @ 10:14:57 GMT

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

We have had loads of "fun" recently with these tables and ended up implementing a solution along the lines already suggested. Since then a chap from NCR suggested that a good approach is to include the timestamp in the Account string of the logons as the expanded account string exists on both tables. This then gives a good join (logically). I haven't have chance to test any of this yet (and won't for some time) so don't know if it will work. Perhaps one of you can do that for me :-)

Howard

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