Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Multiple Output files from 1 Query
 
From:   Graham, Fred

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016