Archives of the TeradataForum

Message Posted: Mon, 05 Apr 2010 @ 15:31:13 GMT

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

Hi everyone, I am using Teradata SQL Assistant and would like to know if there is a way to create a query that creates multiple output files. I have created a volatile table that contains Unit_ID, StartDate, and EndDate. I am using that table as an index to pull data on each unit between the given start and end dates. Because the amount of data for each unit can be quite large, it would be best to have the query create unique output files for each unit. I was hoping to be able to do this without running individual queries. Any suggestions?

Thanks,

Fred

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