Archives of the TeradataForum

Message Posted: Wed, 12 Nov 2014 @ 20:57:31 GMT

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

Hi,

I'm not sure how to answer your specific questions but why are you you're CASting two columns for a join? How about defining them as the same data type (e.g. define CUST_ESTI_DT as a TIMESTAMP(6)) in the table?

Cheers,

Dave

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

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