Archives of the TeradataForum

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

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

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>>