Archives of the TeradataForum

Message Posted: Tue, 19 Sep 2006 @ 17:25:23 GMT

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

I have gotten partition elimination by coding a date range, and then using EXTRACT month and year and doing an equality join on those. Very nice for the users, and it worked well to put the month and year in a view and let them use that for selection criteria.

iv

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