Archives of the TeradataForum

Message Posted: Fri, 21 Dec 2007 @ 10:48:03 GMT

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

Hi Bill,

At the point in your processing where you need to do this check I'm assuming that both sets of data (i.e. the 'new' rows and the existing rows) are in tables on TD. If that assumption is correct...

How about joining two tables with '=' on the key columns and '<>' on all other columns (handling NULLs as you go) ?

Or, how about using the ROWHASH function ? Again, joining two tables with '=' on the key columns and generating the ROWHASH value on all other relevant columns. If the ROWHASH is different then you know that you've got a different set of values. Even if the ROWHASH is the same then you may have to check each column value to finally check for different values.

Just a thought...

Cheers,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )

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