Archives of the TeradataForum
Message Posted: Thu, 11 Jan 2007 @ 09:45:08 GMT
Subj: | | Re: Question regarding dummy table |
|
From: | | ulrich arndt |
Just in case you really need a table - e.g. if you what create a header row combinded by union all with some selects (Unions need to reference
a table):
use sys_calendar.calendar
like
select 'DDD' as whatever
from sys_calendar.calendar
where calendar_date = current_date;
A bit more code in comparison to the big O but will work...
--
Ulrich Arndt
www.data2knowledge.de
|