Archives of the TeradataForum
Message Posted: Thu, 11 Jan 2007 @ 09:45:08 GMT
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):
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...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|