Archives of the TeradataForum

Message Posted: Thu, 27 Jan 2011 @ 20:11:28 GMT

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

Assuming your pivot table is not going to need to be infinitely long, but rather a set period, like a few months, calculate the column dates in your case statements, i.e.. Date - 21, date - 14

You won't have the nice column headings you have assigned.

Dave

David W. Roth
Teradata Certified Master
TERADATA

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