Archives of the TeradataForum

Message Posted: Mon, 01 Dec 2003 @ 12:45:13 GMT

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

Why would you do the union all. Wouldn't the following work? The advantage would be one pass of the table.

select Case
When ColumnName Is Not NULL then ColumnName
Else 0
End
from SomeTable
;

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