Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 17 Jan 2007 @ 12:52:16 GMT


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


Subj:   Re: Question regarding dummy table
 
From:   Rob Paller

Have you tried the following:

     SELECT colA
     FROM .
     UNION
     SELECT 'My Constant'
     FROM SYS_CALENDAR.CALENDAR
     WHERE CALENDAR_DATE = DATE

or

     SELECT colA
     FROM .
     UNION
     SELECT 'My Constant'
     FROM .

Both will work. The first is an attempt to minimize the amount of spool that is consumed by reducing the number of records referenced by using the system calendar table. Your mileage may vary.



     
  <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